mySQL官网:https://dev.mysql.com/downloads/file 本文例子:系统:Linux Centos7 MySQL:mysql-5.7.21
重启:/etc/init.d/mysql restart 10.设置开机启动: chkonfig --level 35 mysql on chkconfig --list mysqld chomd +x/etc/rc.d/init.d/mysql chkconfig -add mysqld chkconfig -list mysqld service mysqld status 11.添加环境变量 vi etc/profile 添加:export PATH=$PATH:/usr/local/mysql/bin 配置文件生效:source /etc/profile 12.获取初始密码(补充) cat /root/.mysql_secret 用mysql -uroot -p登陆MySQL set password for **@localhost = password('密码'); 13.添加远程访问: use mysql; GRANT ALL ON *.* 用户名@'%' IDENTIFIED BY '密码' WITH GRANT OPTION; @'%'是指任主机 用户名是链接时的用户 重启: service mysql restart ---------------------------------------------------------------------------------------------------------------------- 我们尊重原创,也注重分享,文章来源于微信公众号:彼岸花科技,建议关注公众号查看原文。如若侵权请联系qter@qter.org。 ---------------------------------------------------------------------------------------------------------------------- |