hackerzhou's wiki

User Tools

Site Tools

Trace: • travel
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:57] – [MySQL] hackerzhoudev:kb:database:mysql [2020/06/06 23:32] (current) – external edit 127.0.0.1
Line 3: Line 3:
 <code bash> <code bash>
 sudo mysqladmin -u root -p password '<new_password>' 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> </code>
 ==== Create backup account ==== ==== Create backup account ====
dev/kb/database/mysql.1391255856.txt.gz · Last modified: (external edit)