MYSQL adds a new user MYSQL creates a database for the user MYSQL assigns the new user the permission bitsCN.com
MYSQL adds a new user MYSQL creates a database for the user MYSQL assigns permissions to the new user
1. create a user
// Log on to
There are two different ways to add users: using the GRANT statement or directly operating the MySQL authorization table. The better way is to use the GRANT statement, because they are more concise and seem to have fewer errors. The following
1. Create a new userLog in to MySQL@>mysql-u root-p@> Password//create user mysql> insert into Mysql.user (Host,user,password) VALUES (' localhost ', ' JEECN ', Password (' JEECN '));Refresh System Permissions TableMysql>flush privileges;This
1. new User Login MYSQL @ mysql-uroot-p @ password create user mysqlinsertintomysql. user (Host, User, Password) values ('localhost', jeecn', password ('jeecn'); refresh the system permission table mysqlflushprivileges; then a name is created: jeecn
http://apps.hi.baidu.com/share/detail/5530778My MySQL is installed in C:\mysqlFirst, change the passwordThe first way:1. The situation where root does not have a password before changeC:\mysql\bin>mysqladmin-u root password "Your password"2. If the
Han Ligang Teacher Video teaching website http://www.91xueit.comMr. Han QQ458717185No. 01. mysql User and Rights managementMySQL permissions control is controlled by two steps, can not connect (authenticate user identity), what action (verify user
There are two different ways to add users: using the GRANT statement or directly operating the MySQL authorization table. The better way is to use the GRANT statement, because they are more concise and seem to have fewer errors.
MySQL changes User Permissions
This entry was posted by admin Monday, 26 then l, 2010
1. "grant all on *. * to root @ '%' identified by 'yourpassword';" -- the password can also be set along with the password.2. "Flush privileges;" -- refresh to
The MySQL privilege system (controlled by MySQL permissions table user and DB) is certified in the following two ways:1) for the connected users to authenticate, legitimate through authentication, illegal to deny the connection.2) for the user who
1. Create a user // Log on to MySQL@> Mysql-u root-P@> Password// Create a userMysql> insert into mysql. User (host, user, password) values ('localhost', 'jeecn', password ('jeecn '));// Refresh the system permission listMysql> flush privileges;In
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
and provide relevant evidence. A staff member will contact you within 5 working days.