ITPub博客

首页 > 数据库 > MySQL > MySQL YUM源安装与配置

MySQL YUM源安装与配置

原创 MySQL 作者:kwx970125774 时间:2015-11-10 17:30:14 0 删除 编辑
  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博客 ” ,链接:https://blog.itpub.net/26421115/viewspace-1827278/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-10-01

  • 博文量
    8
  • 访问量
    30060