易网时代-编程资源站

首页 / 数据库 / MySQL / CentOS下MySQL安装配置过程详解

1、CentOS下安装MySQL[root@sample ~]# yum -y install mysql-server ← 安装MySQL然后，安装PHP访问MySQL数据库的工具“php-mysql”[root@sample ~]# yum -y install php-mysql ← 安装php-mysql 2、配置MySQL[root@sample ~]# vi /etc/my.cnf ← 编辑MySQL的配置文件#定位到这里[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Default to using old password format for compatibility with mysql 3.x# clients （those using the mysqlclient10 compatibility package）.old_passwords=1 ← 找到这一行，在这一行的下面添加新的规则，让MySQL的默认编码为UTF-8（假若找不到，就在本文件到底添加）default-character-set = utf8 ← 添加这一行启动MySQL服务，进入MySQL里面运行status查看是否已经全部都是支持了utf8，并让MySQL在系统重新启动后随系统自动启动。[root@sample ~]# chkconfig mysqld on ← 设置MySQL服务随系统启动自启动[root@sample ~]# chkconfig --list mysqld ← 确认MySQL自启动mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off ← 如果2--5为on的状态就OK[root@sample ~]# service mysqld start ← 启动MySQL服务 3、设置root用户密码及相关优化配置MySQL在刚刚被安装的时候，它的root用户是没有被设置密码的，首先来设置MySQL的root密码。[root@sample ~]# mysql -u root ← 用root用户登录MySQL服务器Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 2 to server version: 4.1.20Type "help;" or "h" for help. Type "c" to clear the buffer.mysql> select user,host,password from mysql.user; ← 查看用户信息+------+------------------------------+---------------+| user | host | password |+------+------------------------------+---------------+| root | localhost | | ← root密码为空| root | sample.centospub.com | | ← root密码为空| | sample.centospub.com | || | localhost | |+------+------------------------------+---------------+4 rows in set （0.00 sec）mysql> set password for root@localhost=password（"yournewpwd"）; ← 设置root密码Query OK, 0 rows affected （0.01 sec）mysql> set password for root@"sample.centospub.com"=password（"newID"）; ← 设置root密码Query OK, 0 rows affected （0.01 sec）mysql> select user,host,password from mysql.user; ← 查看用户信息+------+--------------------------------+--------------------------+| user | host | password |+------+--------------------------------+--------------------------+| root | localhost | 19b68057189b027f | ← root密码被设置，已经加密| root | sample.centospub.com | 19b68057189b027f | ← root密码被设置，已经加密| | sample.centospub.com | || | localhost | |+------+--------------------------------+--------------------------+4 rows in set （0.01 sec）mysql> exit ← 退出MySQL服务器Bye然后，测试一下root密码有没有生效。[root@sample ~]# mysql -u root ← 通过空密码用root登录ERROR 1045 （28000）: Access denied for user "root"@"localhost" （using password: NO） ← 出现此错误信息说明密码设置成功[root@localhost ~] # mysql -u root -h sample.centospub.com ← 通过空密码用root登录ERROR 1045 （28000）: Access denied for user "root"@"localhost" （using password: NO） ← 出现此错误信息说明密码设置成功[root@sample ~]# mysql -u root -p ← 通过密码用root登录Enter password: ← 在这里输入密码Welcome to the MySQL monitor. Commands end with ; or g. ← 确认用密码能够成功登录Your MySQL connection id is 5 to server version: 4.1.20Type "help;" or "h" for help. Type "c" to clear the buffer.mysql> exit[root@sample ~]# mysql -u root -h sample.centospub.com -p ← 通过密码用root登录Enter password: ← 在这里输入密码Welcome to the MySQL monitor. Commands end with ; or g. ← 确认用密码能够成功登录Your MySQL connection id is 6 to server version: 4.1.20Type "help;" or "h" for help. Type "c" to clear the buffer.mysql> exit ← 退出MySQL服务器Bye 删除匿名用户在MySQL刚刚被安装后，存在用户名、密码为空的用户。这使得数据库服务器有无需密码被登录的可能性，为消除隐患，将匿名用户删除。[root@sample ~]# mysql -u root -p ← 通过密码用root登录Enter password: ← 在这里输入密码Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 7 to server version: 4.1.20Type "help;" or "h" for help. Type "c" to clear the buffer.mysql> select user,host from mysql.user; ← 查看用户信息+------+----------------------------+| user | host |+------+----------------------------+| | localhost || | 127.0.0.1 || root | localhost || | sample.centospub.com || root | sample.centospub.com |+------+----------------------------+4 rows in set （0.02 sec）mysql> delete from mysql.user where user=""; ← 删除匿名用户Query OK, 2 rows affected （0.17 sec）mysql> select user,host from mysql.user; ← 查看用户信息+------+----------------------------+| user | host |+------+----------------------------+| root | localhost || root | sample.centospub.com |+------+----------------------------+2 rows in set （0.00 sec）mysql> exit ← 退出MySQL服务器删除测试用数据库在MySQL被安装后，存在名为test的空数据库，将它删除。这里要注意的是，系统默认的还有一个名为mysql的数据库，它用于系统管理，所以请不要删除。[root@sample ~]# mysql -u root -p ← 通过密码用root登录Enter password: ← 在这里输入密码Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 8 to server version: 4.1.20Type "help;" or "h" for help. Type "c" to clear the buffer.mysql> show databases; ← 查看系统已存在的数据库+-------------+| Database |+-------------+| mysql || test |+------------+2 rows in set （0.02 sec）mysql> drop database test; ← 删除名为test的空数据库Query OK, 0 rows affected （0.07 sec）mysql> show databases; ← 查看系统已存在的数据库+-------------+| Database |+-------------+| mysql | ← 确认名为test的数据库被删除，已不存在+-------------+1 row in set （0.00 sec）mysql> exit ← 退出MySQL服务器 4、测试MySQL下面对MySQL进行测试。包括建立新用户，以及用对关系性数据库进行数据库操作的指令来试着建立数据库及数据表，这里，新建用户以centospub为例。[root@sample ~]# mysql -u root -p ← 通过密码用root登录Enter password: ← 在这里输入密码Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 9 to server version: 4.1.20Type "help;" or "h" for help. Type "c" to clear the buffer.mysql> grant all privileges on test.* to centospub@localhost identified by "newpwd’; ← 建立对test数据库有完全操作权限的名为centospub的用户Query OK, 0 rows affected （0.03 sec）mysql> select user from mysql.user where user="centospub"; ← 确认centospub用户的存在与否+---------+| user |+---------+| centospub | ← 确认centospub已经被建立+---------+1 row in set （0.01 sec）mysql> exit ← 退出MySQL服务器[root@sample ~]# mysql -u centospub -p ← 用新建立的centospub用户登录MySQL服务器Enter password: ← 在这里输入密码Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 10 to server version: 4.1.20Type "help;" or "h" for help. Type "c" to clear the buffer.mysql> create database test; ← 建立名为test的数据库Query OK, 1 row affected （0.00 sec）mysql> show databases; ← 查看系统已存在的数据库+-------------+| Database |+-------------+| test |+-------------+1 row in set （0.00 sec）mysql> use test; ← 连接到数据库Database changedmysql> create table test（num int, name varchar（50））; ← 在数据库中建立表Query OK, 0 rows affected （0.03 sec）mysql> show tables; ← 查看数据库中已存在的表+-------------------+| Tables_in_test |+-------------------+| test |+-------------------+1 row in set （0.01 sec）mysql> insert into test values（1,"Hello World！"）; ← 插入一个值到表中Query OK, 1 row affected （0.02 sec）mysql> select * from test; ← 查看数据库中的表的信息+------+-------------------+| num | name |+------+-------------------+| 1 | Hello World！ |+------+-------------------+1 row in set （0.00 sec）mysql> update test set name="Hello Everyone！"; ← 更新表的信息，赋予新的值Query OK, 1 row affected （0.00 sec）Rows matched: 1 Changed: 1 Warnings: 0mysql> select * from test; ← 查看数据库中的表的信息+------+----------------------+| num | name |+------+----------------------+| 1 | Hello Everyone！ | ← 确认被更新到新的值+------+----------------------+1 row in set （0.01 sec）mysql> delete from test where num=1; ← 删除表内的值Query OK, 1 row affected （0.00 sec）mysql> select * from test; ← 确认删除结果Empty set （0.01 sec）mysql> drop table test; ← 删除表Query OK, 0 rows affected （0.01 sec）mysql> show tables; ← 查看表信息Empty set （0.00 sec） ← 确认表已被删除mysql> drop database test; ← 删除名为test的数据库Query OK, 0 rows affected （0.01 sec）mysql> show databases; ← 查看已存在的数据库Empty set （0.01 sec） ← 确认test数据库已被删除（这里非root用户的关系，看不到名为mysql的数据库）mysql> exit ← 退出MySQL服务器Bye 然后，删除测试用过的遗留用户。[root@sample ~]# mysql -u root -p ← 通过密码用root登录Enter password: ← 在这里输入密码Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 12 to server version: 4.1.20Type "help;" or "h" for help. Type "c" to clear the buffer.mysql> revoke all privileges on *.* from centospub@localhost; ← 取消centospub用户对数据库的操作权限Query OK, 0 rows affected （0.00 sec）mysql> delete from mysql.user where user="centospub" and host="localhost"; ← 删除centospub用户Query OK, 1 row affected （0.01 sec）mysql> select user from mysql.user where user="centospub"; ← 查找用户centospub，确认已删除与否Empty set （0.01 sec） ← 确认centospub用户已不存在mysql> flush privileges; ← 刷新，使以上操作生效Query OK, 0 rows affected （0.01 sec）mysql> exitBye 5、最后，重新启动一次HTTP服务，让php-mysql反映到HTTP服务中。[root@sample ~]# /etc/rc.d/init.d/httpd restart ← 重新启动HTTP服务Stopping httpd: [ OK ]Starting httpd: [ OK ]更多CentOS相关信息见CentOS 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=14phpMyAdmin提示“Access denied for user "root"@"localhost" （using password: NO）”的解决办法关于MySQL中文乱码的完美解决方案相关资讯 CentOS安装MySQL CentOS配置MySQL

CentOS 6.7安装MySQL （今 20:50）
CentOS6.7 64位环境下安装部署（07月28日）
CentOS 7 安装 MySQL5.6.22 （12/23/2015 14:09:32）

CentOS 7.0下使用yum安装MySQL （09月06日）
如何在CentOS6.5系统上安装免编译（06月13日）
CentOS 7下安装MySQL （12/23/2015 14:06:02）

本文评论查看全部评论（0）