Difference between revisions of "MYSQL-notes"
From Wiki at Neela Nurseries
m (→MYSQL Reset Root Password) |
(2017-10-19 THU - Ted adding overview section, and section of notes on how to configure two or more MYSQL servers on a given host.) |
||
| Line 3: | Line 3: | ||
__TOC__ | __TOC__ | ||
| + | |||
| + | |||
| + | == OVERVIEW == | ||
| + | |||
| + | This wiki article holds Ted's notes on configuring, deploying, backing up and restoring MYSQL database servers and databases. | ||
| + | |||
| + | |||
| + | |||
| + | <!-- comment --> | ||
== MYSQL Reset Root Password == | == MYSQL Reset Root Password == | ||
| Line 41: | Line 50: | ||
mysql> | mysql> | ||
</pre> | </pre> | ||
| + | |||
| + | |||
| + | |||
| + | <!-- comment --> | ||
| + | |||
| + | == MYSQL Multiple Servers On One Host == | ||
| + | |||
| + | * [https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html MYSQL 5.7 documentation - multiple servers] | ||
| + | |||
Revision as of 22:34, 19 October 2017
OVERVIEW
This wiki article holds Ted's notes on configuring, deploying, backing up and restoring MYSQL database servers and databases.
MYSQL Reset Root Password
mysql> select Host, User, authentication_string from user;
+---------------+------------------+-------------------------------------------+
| Host | User | authentication_string |
+---------------+------------------+-------------------------------------------+
| localhost | root | *7DED8F04F1F0C0639D9631FEFFDA4539EE31DD17 |
| ubuntu-spare-2| root | *7DED8F04F1F0C0639D9631FEFFDA4539EE31DD17 |
| 127.0.0.1 | root | *7DED8F04F1F0C0639D9631FEFFDA4539EE31DD17 |
| ::1 | root | *7DED8F04F1F0C0639D9631FEFFDA4539EE31DD17 |
| localhost | debian-sys-maint | *E8C7D3BB3A512229A60E85B7A2A23484ED003A94 |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | wikiuser | *F05B4F375EA1AC92DB6916D2F25E41B5689539FD |
+---------------+------------------+-------------------------------------------+
7 rows in set (0.02 sec)
mysql> update user set authentication_string=PASSWORD("new-root-password-to-mysql") where User='root';
Query OK, 4 rows affected, 1 warning (0.02 sec)
Rows matched: 4 Changed: 4 Warnings: 1
mysql> select Host, User, authentication_string from user;
+---------------+------------------+-------------------------------------------+
| Host | User | authentication_string |
+---------------+------------------+-------------------------------------------+
| localhost | root | *A070565E56DA8DBCF462EEE4A67C59881CC60597 |
| ubuntu-spare-2| root | *A070565E56DA8DBCF462EEE4A67C59881CC60597 |
| 127.0.0.1 | root | *A070565E56DA8DBCF462EEE4A67C59881CC60597 |
| ::1 | root | *A070565E56DA8DBCF462EEE4A67C59881CC60597 |
| localhost | debian-sys-maint | *E8C7D3BB3A512229A60E85B7A2A23484ED003A94 |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | wikiuser | *F05B4F375EA1AC92DB6916D2F25E41B5689539FD |
+---------------+------------------+-------------------------------------------+
7 rows in set (0.00 sec)
mysql>
MYSQL Multiple Servers On One Host
References
- 2017-07-xx -
- https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/
- https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password
- 2017-07-27 Thursday -
- https://www.digitalocean.com/community/tutorials/how-to-move-a-mysql-data-directory-to-a-new-location-on-ubuntu-16-04
- https://dev.mysql.com/doc/refman/5.7/en/show-variables.html
