wget wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpmsudo yum localinstall mysql80-community-release-el7-3.noarch.rpmsudo yum install mysql-server -ysudo systemctl start mysqldsudo systemctl status mysqldsudo systemctl enable mysqldsudo grep 'temporary password' /var/log/mysqld.logsudo mysql_secure_installationmysqladmin -u root -p versionmysql -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>\qsudo systemctl restart mysql免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
