yum mysql 源_MySQL YUM源安装与配置

1. 通过yum源安装MySQL，在安装MySQL前需要安装perl-DBI及perl-DBD-MySQL，为了方便期间统一通过yum源一键式搞定。

[root@mysqlserver ~]# yum -y install perl-DBI perl-DBD-MySQL  mysql mysql-server

2. 安装完MySQL后需要初始化MySQL数据库。

[root@mysqlserver ~]# mysql_install_db

Installing MySQL system tables...

OK

Filling help tables...

OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

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 'new-password'

/usr/bin/mysqladmin -u root -h mysqlserver 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.

You can start the MySQL daemon with:

cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

3. 修改mysql目录权限

[root@mysqlserver ~]# chown -R mysql /var/lib/mysql

[root@mysqlserver ~]# chgrp -R mysql /var/lib/mysql

[root@mysqlserver ~]# ls -ltr /var/lib/mysql

total 8

drwx------ 2 mysql mysql 4096 Nov  6 17:17 test

drwx------ 2 mysql mysql 4096 Nov  6 17:17 mysql

4. 修改mysql配置文件，使其支持中文及期远程连接。

[root@mysqlserver ~]# vi /etc/my.cnf

[mysqld]

default-storage-engine=INNODB

character-set-server=utf8

collation-server=utf8_general_ci

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

skip-grant-tables

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

[client]

default-character-set=utf8

5.  启动MySQL服务

[root@mysqlserver ~]# service mysqld restart

Stopping mysqld:                                           [  OK  ]

Starting mysqld:                                           [  OK  ]

6. 修改root用户的口令，并测试连接

[root@mysqlserver ~]# mysqladmin -u root password mysql

[root@mysqlserver ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

出现了“mysql>”提示符，表示安装成功，mysql已经正常启动。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26421115/viewspace-1827278/，如需转载，请注明出处，否则将追究法律责任。