Home >Database >Mysql Tutorial >mysql 编码设置命令_MySQL
mysql 编码设置命令_MySQL
- WBOYOriginal
- 2016-06-01 13:19:461008browse
bitsCN.com
查看编码：
SHOW VARIABLES LIKE 'character%';或status:
修改：set 变量=置
SET character_set_client = utf8 ;
mysql修改root密码
方法一:
(适用于管理员或者有全局权限的用户重设其它用户的密码)
进入命令行模式
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='name';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
最简单的方法。bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：巧用mysql提示符prompt清晰管理数据库的方法_MySQLNext article：提高MySQL中数据装载效率_MySQL