hackerzhou's wiki

User Tools

Site Tools

Trace:
dev:kb:database:mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
dev:kb:database:mysql [2014/02/01 11:55] – hackerzhoudev:kb:database:mysql [2020/06/06 23:32] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ====== MySQL ====== ====== MySQL ======
 +==== Update MySQL root password ====
 +<code bash>
 +sudo mysqladmin -u root -p password '<new_password>'
 +</code>
 +
 +==== Allow MySQL root remote access ====
 +<code sql>
 +update mysql.user set host = '%' where user = 'root';
 +</code>
 ==== Create backup account ==== ==== Create backup account ====
 <code sql> <code sql>
dev/kb/database/mysql.1391255700.txt.gz · Last modified: (external edit)