卸载MySQL
yum -y remove mysql
yum -y remove mysql*
安装MySQL
yum -y install mysql-server
(使用rpm安装:rpm -ivh mysql-community-*)
查看MySQL安装路径
whereis mysql
启动MySQL
service mysqld start
设置密码
/usr/bin/mysqladmin -uroot password 'root'
连接MySQL
mysql -uroot -proot
MySQL远程连接授权(先启动MySQL)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
查看mysql日志
tail -f /var/log/mysqld.log
yum -y remove mysql
yum -y remove mysql*
安装MySQL
yum -y install mysql-server
(使用rpm安装:rpm -ivh mysql-community-*)
查看MySQL安装路径
whereis mysql
启动MySQL
service mysqld start
设置密码
/usr/bin/mysqladmin -uroot password 'root'
连接MySQL
mysql -uroot -proot
MySQL远程连接授权(先启动MySQL)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
查看mysql日志
tail -f /var/log/mysqld.log