Linux下安装Mysql

Linux for Mysql 下载地址：http://www.mysql.com/downloads/mysql-4.0.html#downloads

我的环境：redhat 企业版6.1

首先查看Linux系统中是否有自带Mysql

#rpm -qa | grep -i mysql

我的显示如下

mysql-5.1.52-1.el6_0.1.i686

mysql-devel-5.1.52-1.el6_0.1.i686

mysql-libs-5.1.52-1.el6_0.1.i686

#yum remove mysql

#rpm -ivh MySQL-server-5.5.23-1.el6.i686.rpm

#rpm -ivhMySQL-client-5.5.23-1.el6.i686.rpm

#service mysql start(启动Mysql数据库)

#mysqladmin -uroot password 新密码

#mysql -uroot -p新密码

你想myuser使用mypassword从任何主机连接到mysql服务器的话。

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器，并使用mypassword作为密码

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器的dk数据库，并使用mypassword作为密码

GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;