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 | |||
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
