First, declare that, in general, you need to have the root permission in MySQL to modify the mysql password and grant permissions. Note: this operation is performed at the WIN command prompt, and phpMyAdmin is also applicable. User: phplamp user
MySQLStudy-MySQL User and permission management MySQL server uses the MySQL permission table to control user access to the database. the MySQL permission table is stored in the mysql database and initialized by the mysql_install_db script. These
1. download MySql
1. download MySql
Open http://www.mysql.com/downloads/mysql/#downloads download in browser
My downloaded version is Red Hat 5 version of http://www.mysql.com/downloads/mirror.php? Id = 407552
Upload the file to the server, or
The main function of the MySQL privilege system is to verify the user connected to a given host and give the user relevant DML,DQL permissions on the database. MySQL access control contains 2 stages, one is that the server checks whether you are
management of MySQL usersFirst, view the current Connection account information1.1, view the current database to connect the account informationUse command: Show ProcesslistMySQL [(None)]> show processlist;+--------+-------------+--------------------
You can use create user or grant to create a user, which is also assigned relevant permissions. Revoke is used to delete user permissions and drop user to delete accounts.
$ Mysql-u root-ppassword: mysql> Create Database test; # create database
Http://www.rainsts.net/article.asp? Id = 988
You can use create user or grant to create a user, which is also assigned relevant permissions. Revoke is used to delete user permissions and drop user to delete accounts.
$ Mysql-u root-ppassword: mysql>
======== password action for root user (change user password)========Just installed MySQL, only one has a root user, password is empty, and can only be logged in the machine!add password xxx123 to root:./bin/mysqladmin-u Root Password xxx123or
User management of the MySQL database user and log management database1.mysql user account management user account [email protected] Username: Account name host: Which client host requests this account can create connection threads, which can be IP,
Reference blog:Linux Learning CentOS (13) installation and configuration of MySQL database under--centos6.4MySQL multiple ways to change the root passwordBackup and restore of MySQLTroubleshoot MySQL import restore when the problem is garbledMySQL
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:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.