linux下安装MySQL

来源:互联网 发布:中国广电网络缴费 编辑:程序博客网 时间:2024/05/22 00:20
#安装mysql:    sudo apt-get install mysql-server    sudo apt install mysql-client    sudo apt install libmysqlclient-dev #检查MySQL是否安装成功:    sudo netstat -tap | grep mysql 或者 netstat -tap | grep mysql#开启远程访问mysql         #编辑mysql配置文件,注释掉“bind-address = 127.0.0.1”        vi /etc/mysql/mysql.conf.d/mysqld.cnf         #bind-address = 127.0.0.1       #进入mysql root账户     mysql -u root -p 123456#让root用户远程访问:        GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;        #刷新flush privileges;        flush privileges;#重启MySQL        /etc/init.d/mysql restart 
0 0
原创粉丝点击