RedHat中RPM方式安装MySQL Server(5.5)
1、检查查询是否已经安装MySQL#rpm -qa|grep mysql
2、若存在不同版本的MySQL，卸载系统中已经安装的MySQL
#rpm -e --nodeps mysql;
3、安装MySQL Server
#rpm -ivh MySQL-server-5.5.32-1.rhel5.x86_64.rpm
# rpm -ivh MySQL-server-5.5.32-1.rhel5.x86_64.rpm
Preparing... ###########################################
1:MySQL-server ###########################################
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'my'
/usr/bin/mysqladmin -u root -h dev222 password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default.This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
4、安装MySQL Client
# rpm -ivh MySQL-client-5.5.32-1.rhel5.i386.rpm
Preparing... ###########################################
1:MySQL-client ###########################################
5、更改MySQL保存的数据目录为/data
默认的情况下，数据库的安装目录是安装在/usr/lib/mysql中的，更改为/data目录，可按照如下步骤：
6、在根目录/下建立data目录
#mkdir /data
7、把/var/lib/mysql整个目录移到/data
#mv /var/lib/mysql /data/
这样就把MySQL的数据文件移动到了/data/mysql下
8、找到my.cnf配置文件
如果/etc/目录下没有my.cnf配置文件，请到/usr/share/mysql/下找到*.cnf文件，拷贝其中一个到/etc/并改名为my.cnf)中。命令如下：
# cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
9、编辑MySQL的配置文件/etc/my.cnf
为保证MySQL能够正常工作，需要指明mysql.sock文件的产生位置。修改socket=/var/lib/mysql/mysql.sock一行中等号右边的值为：/data/mysql/mysql.sock 。操作如下：
port = 3306
socket = /data/mysql/mysql.sock
10、修改目录的宿主和权限为mysql
chown -R mysql:mysql /data
11、安装默认数据库
#mysql_install_db --datadir=/data
12、修改MySQL的root用户的密码以及打开远程连接
# mysql -u root mysql
mysql>use mysql;
mysql>desc user;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "my"; //为root添加远程连接的能力。
mysql>update user set Password = password('my') where User='root';
mysql>select Host,User,Passwordfrom user where User='root';
mysql>flush privileges;
mysql>exit
13、修改/etc/passwd中mysql对应的用户Home目录为/data
页:
[1]