linu下在线安装mysql
https://blog.csdn.net/weixin_40271036/article/details/79528593
https://blog.csdn.net/gcxzflgl/article/details/79929557
查看系统之前是否已安装MySQL:
rpm -qa | grep mysql
有的话,卸载
rpm -e mysql-libs-5.1.73-5.el6_6.x86_64 --nodeps
在线 yum安装mysql
yum install mysql mysql-server mysql-devel
安装完启动mysql :
systemctl start mariadb
查看安装没:
rpm -qa |grep mariadb
安装:mariadb-server
yum -y install mariadb-server
启动mysql:
mysql
进入mysql 控制台:
mysql>USE mysql;
mysql>UPDATE user SET Password=PASSWORD('123') WHERE user='root'; --修改用户名和密码,修改root的账户密码为:123
mysql>FLUSH PRIVILEGES;
允许远程登录 :
mysql -u root -p
Enter Password: <your new password>
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
mysql服务名字:
service mysqld start
设置为开机自启: 设置为开机自启时需要退出 mysql> 命令为:exit
设置为开机自启
chkconfig mysqld on
chkconfig mysqld --list
添加开机启动,查看是否开机启动
systemctl enabled mariadb
systemctl is-enabled mariadb