blog
code
freebsd
gitweb
math
pics
travel
writing
share
|
Adding a new mysql user
To add a new mysql user called 'new_user' with the password 'badpassword':
<![CDATA[
mysql> use mysql;
Database changed
mysql> INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv)
VALUES ('localhost', 'new_user', PASSWORD('badpassword'), 'Y', 'Y', 'Y');
Query OK, 1 row affected (0.20 sec)
mysql> INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv)
VALUES ('127.0.0.1', 'new_user', PASSWORD('badpassword'), 'Y', 'Y', 'Y');
Query OK, 1 row affected (0.20 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 1 row affected (0.01 sec)
mysql> select User,Password,Host from user where user = 'new_user';
+----------+-------------------------------------------+-----------+
| User | Password | Host |
+----------+-------------------------------------------+-----------+
| new_user | *F4A5147613F01DEC0C5226BF24CD1D5762E6AAF2 | localhost |
| new_user | *F4A5147613F01DEC0C5226BF24CD1D5762E6AAF2 | 127.0.0.1 |
+----------+-------------------------------------------+-----------+
2 rows in set (0.00 sec)
]]>
Now you should be able to login to the mysql server from the local machine.
|
|
del.icio.us
