Difference between revisions of "Database"

From Anarchaserver
 
(2 intermediate revisions by the same user not shown)
Line 16: Line 16:
------------------------------------------------------
------------------------------------------------------
</code>
</code>


How to configure root access to mysql without login/password
How to configure root access to mysql without login/password
Line 26: Line 28:
<code>[client]
<code>[client]
password=(x)
password=(x)
[mysqldump]
quick


</code>
</code>
Line 32: Line 37:
How to locate phypmyadmin
How to locate phypmyadmin
dpkg -l | grep phpmyadmin
dpkg -l | grep phpmyadmin
ii  phpmyadmin                    4:3.4.11.1-2+deb7u1           all          MySQL web a
 
ii  phpmyadmin                     
4:3.4.11.1-2+deb7u1

Latest revision as of 16:10, 13 August 2017

mysql -u root -p


mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | anarcha | | mysql | | performance_schema | | zoiahorn | +--------------------+



How to configure root access to mysql without login/password

https://dev.mysql.com/doc/refman/5.7/en/option-files.html

cd /root/home nano .my.cnf

[client] password=(x)

[mysqldump] quick


How to locate phypmyadmin dpkg -l | grep phpmyadmin

ii phpmyadmin 4:3.4.11.1-2+deb7u1