1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| $ sudo /etc/init.d/mysql stop
$ sudo mysqld_safe --skip-grant-tables &
$ mysql -uroot -p
mysql> use mysql
mysql> insert into user(host,user,password) values('%','username',password('12345678'));
$ mysqladmin shutdown
$ sudo /etc/init.d/mysql start
$ mysql -uroot -p
mysql> grant all privileges on userdb.* to username@localhost;
mysql> flush privileges;
$ sudo /etc/init.d/mysql restart
|