Mysql安装成功后,默认的root用户密码为空,你可以使用以下命令来创建root用户的密码:
[root@host]# mysqladmin -u root password "new_password";
现在你可以通过以下命令来连接到Mysql服务器:
[root@host]# mysql -u root -p
Enter password:*******
注意:在输入密码时,密码是不会显示了,你正确输入即可。
一、创建数据库
mysql> create database news character set utf8;
Query OK, 0 rows affected (0.09 sec)
二、创建用户
mysql> create user 'news'@'39.15.16.14' identified by '123news';
Query OK, 0 rows affected (0.09 sec)
三、授权用户
mysql> grant all privileges on news.* to 'news'@'39.15.16.14';
Query OK, 0 rows affected (0.10 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
或者 这种方法 :创建并授权用户,是二和三的合并。
mysql> grant all on asd.* to 'wanghz'@'192.168.1.%' identified by 'w123'
Query OK, 0 rows affected (0.09 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)
四、删除用户
查看用户信息
mysql> select distinct * from (select user.Host,user.User,db.Db,user.Password,user.Drop_priv,user.Grant_priv,user.Alter_priv from db inner JOIN user on db.user=user.user) as it where user='wanghz';
+------+--------+-----------+-------------------------------------------+-----------+------------+------------+
| Host | User | Db | Password | Drop_priv | Grant_priv | Alter_priv |
+------+--------+-----------+-------------------------------------------+-----------+------------+------------+
| % | wanghz | asd | *D98C88AFF81F2B8C5A0930313CD1250C6D81672E | N | N | N |
+------+--------+-----------+-------------------------------------------+-----------+------------+------------+
1 row in set (0.00 sec)
mysql> select * from user where user='wanghz'\G;
*************************** 1. row ***************************
Host: %
User: wanghz
Password: *D98C88AFF81F2B8C5A0930313CD1250C6D81672E
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
Create_tablespace_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
plugin: mysql_native_password
authentication_string:
password_expired: N
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> select * from db where user='wanghz'\G;
*************************** 1. row ***************************
Host: %
Db: asd
User: wanghz
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Grant_priv: N
References_priv: Y
Index_priv: Y
Alter_priv: Y
Create_tmp_table_priv: Y
Lock_tables_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Execute_priv: Y
Event_priv: Y
Trigger_priv: Y
1 row in set (0.00 sec)
ERROR:
No query specified
mysql>
删除用户
mysql> drop user 'wanghz'@'%';
Query OK, 0 rows affected (0.02 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)