Difference between revisions of "Database"
From Anarchaserver
(Created page with "<code>mysql -u root -p</code> ------------------------------------------------------ mysql> show databases; +--------------------+ | Database | +-------------------...") |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<code>mysql -u root -p</code> | <code>mysql -u root -p</code> | ||
<code> | |||
------------------------------------------------------ | ------------------------------------------------------ | ||
mysql> show databases; | mysql> show databases; | ||
| Line 14: | Line 15: | ||
------------------------------------------------------ | ------------------------------------------------------ | ||
</code> | |||
How to configure root access to mysql without login/password | |||
https://dev.mysql.com/doc/refman/5.7/en/option-files.html | |||
<code>cd /root/home </code> | |||
<code>nano .my.cnf</code> | |||
<code>[client] | |||
password=(x) | |||
[mysqldump] | |||
quick | |||
</code> | |||
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
