您好,登录后才能下订单哦!
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
wget wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm
sudo yum install mysql-server -y
sudo systemctl start mysqld
sudo systemctl status mysqld
sudo systemctl enable mysqld
sudo grep 'temporary password' /var/log/mysqld.log
sudo mysql_secure_installation
mysqladmin -u root -p version
mysql -u root -p
创建库
mysql>create database testdb;
创建用户
mysql>create user test IDENTIFIED by 'zxc123';
授权给用户
mysql>GRANT ALL PRIVILEGES ON testdb.* TO test@'%';
检查用户权限
mysql>use mysql;
mysql>select user,host from user;
更新权限
mysql>FLUSH PRIVILEGES;
退出
mysql>\q
sudo systemctl restart mysql
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。