Difference between revisions of "Database"
From Anarchaserver
Line 18: | Line 18: | ||
How to configure root access to mysql without login/password | How to configure root access to mysql without login/password | ||
https://dev.mysql.com/doc/refman/5.7/en/option-files.html | https://dev.mysql.com/doc/refman/5.7/en/option-files.html | ||
Revision as of 18:27, 24 July 2016
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="4PEL;[':"
[mysqldump]
quick
How to locate phypmyadmin
dpkg -l | grep phpmyadmin
ii phpmyadmin 4:3.4.11.1-2+deb7u1 all MySQL web a