Home >Database >Mysql Tutorial >mysql常用的小技巧_MySQL
mysql常用的小技巧_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:41:001048browse
bitsCN.com
mysql常用的小技巧 1.输入原密码。接着设置新密码 代码:mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword'); 2.若你想新建一个具有所有权限的新用户 代码:GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION; 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数据库大小写敏感问题_MySQLNext article：INNER LEFT RIGHT JOIN语句_MySQL