Mysql数据库一句话问题
- WBOYOriginal
- 2016-06-07 16:51:371546browse
1:初始化root密码mysqladmin -uroot password quot;initpasswordquot;2:修改密码mysql -uroot -p password quot;newpassword
1:初始化root密码
mysqladmin -uroot password "initpassword"
2:修改密码
mysql -uroot -p password "newpassword"
Enter password:[ enter old password ]
3:建用户赋予单个库的任意连接权限
create database newdb;
grant select, insert, update, delete,create,alter,index,drop on newdb.* to 'user'@'%' identified by '123456';
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：Ubuntu上的MySQL字符集设置技巧Next article：重新安装主机后ORACLE DB的处理