redhat下mysql安装与使用
时间:2022-03-14 05:28
(1)查看是否安装
yum list installed mysql*
(2)查看现有安装包
yum list mysql*
(3)安装mysql服务器端
yum install mysql-dev
yum install mysql-server
(4)安装mysql客户端(可选)
yum install mysql
(1)设置默认字符和引擎
vim /etc/my.cnf
在[mysqld]下添加
default-character-set=utf8
default-storage-engine=INNODB
(1)启动和关闭
/etc/init.d/mysqld start
/etc/init.d/mysqld stop
(2)开机启动
/sbin/chkconfig - - list
/sbin/chkconfig add mysqld
/sbin/chkconfig mysqld on
(1)你想myuser使用mypassword从任何主机连接到mysql的话:
GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;
FLUSH PRIVILEGES;
(1)
(2)
(3)
redhat下mysql安装与使用,布布扣,bubuko.com