MySQL password change methods, yc sorting, mysqlyc

MySQL password change methods, yc sorting, mysqlyc

Reprinted please indicate the source http://blog.csdn.net/yc7369

MySQL password change methods

I have sorted out the following four methods to change the root password in MySQL, which may be helpful to you!

Method 1: use the set password command

Mysql-uroot

Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass ');

Method 2: Use mysqladmin

Mysqladmin-u root password "newpass"

If the root user has set a password, use the following method:

Mysqladmin-u root password oldpass "newpass"

Method 3: Use UPDATE to directly edit the user table

Mysql-uroot

Mysql> use mysql;

Mysql> UPDATE user SET Password = PASSWORD ('newpass') WHERE user = 'root ';

Mysql> flush privileges;

When the root password is lost

Mysqld_safe -- skip-grant-tables &

Mysql-uroot mysql

Mysql> UPDATE user SET password = PASSWORD ("new password") WHERE user = 'root ';

Mysql> flush privileges;

The following statement is available in mysql 5.6. It should be similar in other versions.

Reprinted please indicate the source http://blog.csdn.net/yc7369

How can I change the sorting attribute of a table in MYSQL?

This is an option you should choose when creating a table. Even if you change the table attributes, the data cannot be changed. There is only one way to query and convert the table using php, and a new utf8 table exists, be sure to create a new one. Otherwise, it is invalid. Please note that this conversion operation will take too much time and effort for the next time.

How to change mysql Encoding

Solution: Open the mysql installation directory: C: \ Program Files \ MySQL Server 5.5
Open the my. ini configuration file, find default-character-set = latin1, and change it:
Default-character-set = gbk, find character-set-server = latin1 and change it:
Character-set-server = gbk. Save the modification.
Finally, right-click "manage" on my computer and select "service" under "services and applications"
Find "mysql" and Right-click and select "restart ".
Set <% @ page language = "java" import = "java. util. * "pageEncoding =" ISO-8859-1 "%> changed to <% @ page language =" java "import =" java. util. * "pageEncoding =" UTF-8 "%> OK