Difference between revisions of "Database"
From Anarchaserver
| 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 | ||
Revision as of 16:09, 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 all MySQL web a
