【文件属性】:
文件名称:ubuntu安装mysql详情步骤.txt
文件大小:931B
文件格式:TXT
更新时间:2022-08-10 06:42:00
mysql ubuntu安装mysql
ubuntu 安装MySQL 支持远程访问
sudo apt-get update
sudo apt-get install mysql-server
sudo apt-get install libmysqlclient-dev
登录 MySQL
mysql -u root -p
创建用户
REATE USER 'username'@'host' IDENTIFIED BY 'password';
进行授权用来远程连接
GRANT ALL PRIVILEGES ON *.* TO 'Ubuntu'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
删除授权
revoke insert,update,delete,select ON *.* from 'Ubuntu'@'%' IDENTIFIED BY '123456';
腾讯云出现权限不够的问题:
http://bbs.qcloud.com/thread-11554-1-1.html
重新启动(命令如下):
/etc/init.d/mysql stop
/etc/init.d/mysql start
执行 flush privileges;命令立即生效
flush privileges;
查询数据库的用户(看到如下内容表示创建新用户成功了)
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
使用exit命令退出MySQL
exit