Difference between revisions of "Database"
From Anarchaserver
(Created page with "<code>mysql -u root -p</code> ------------------------------------------------------ mysql> show databases; +--------------------+ | Database | +-------------------...") |
|||
| 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="4PEL;[':" | |||
[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 all MySQL web a | ii phpmyadmin 4:3.4.11.1-2+deb7u1 all MySQL web a | ||
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
