CentOS6.9下MySQL的安装

最新推荐文章于 2025-05-31 16:36:51 发布

原创最新推荐文章于 2025-05-31 16:36:51 发布 · 3.2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Linux #centos #MySQL #密码

php小白成长之路专栏收录该内容

25 篇文章

订阅专栏

1、查看yum下提供的MySQL版本信息

[root@localhost script]# yum list | grep mysql
mysql.x86_64                               5.1.73-8.el6_8              @base    
mysql-devel.x86_64                         5.1.73-8.el6_8              @base    
mysql-libs.x86_64                          5.1.73-8.el6_8              @base    
apr-util-mysql.x86_64                      1.3.9-3.el6_0.1             base     
bacula-director-mysql.x86_64               5.0.0-13.el6                base     
bacula-storage-mysql.x86_64                5.0.0-13.el6                base     
dovecot-mysql.x86_64                       1:2.0.9-22.el6              base     
freeradius-mysql.x86_64                    2.2.6-7.el6_9               updates  
libdbi-dbd-mysql.x86_64                    0.8.3-5.1.el6               base     
mod_auth_mysql.x86_64                      1:3.0.0-11.el6_0.1          base     
mysql-bench.x86_64                         5.1.73-8.el6_8              base     
mysql-connector-java.noarch                1:5.1.17-6.el6              base     
mysql-connector-odbc.x86_64                5.1.5r1144-7.el6            base     
mysql-devel.i686                           5.1.73-8.el6_8              base     
mysql-embedded.i686                        5.1.73-8.el6_8              base     
mysql-embedded.x86_64                      5.1.73-8.el6_8              base     
mysql-embedded-devel.i686                  5.1.73-8.el6_8              base     
mysql-embedded-devel.x86_64                5.1.73-8.el6_8              base     
mysql-libs.i686                            5.1.73-8.el6_8              base     
mysql-server.x86_64                        5.1.73-8.el6_8              base     
mysql-test.x86_64                          5.1.73-8.el6_8              base     
pcp-pmda-mysql.x86_64                      3.10.9-9.el6                base     
php-mysql.x86_64                           5.3.3-49.el6                base     
qt-mysql.i686                              1:4.6.2-28.el6_5            base     
qt-mysql.x86_64                            1:4.6.2-28.el6_5            base     
rsyslog-mysql.x86_64                       5.8.10-10.el6_6             base     
rsyslog7-mysql.x86_64                      7.4.10-7.el6                base

2、安装MySQL

[root@localhost script]# yum install -y mysql-server mysql mysql-deve

安装成功后最后提示：

Installed:
  mysql-server.x86_64 0:5.1.73-8.el6_8                                                          

Dependency Installed:
  perl-DBD-MySQL.x86_64 0:4.013-3.el6                                                           

Complete!

3、开启MySQL，首次会初始化

[root@localhost script]# service mysqld start
Initializing MySQL database:  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 localhost.localdomain password 'new-password'

4、重启MySQL

[root@localhost script]# service mysqld restart

5、修改密码

[root@localhost script]# mysqladmin -u root password 123456

6、连接

[root@localhost script]# mysql -u root -p
Enter password:

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

mysql>