centos5.2在线安装mysql

最新推荐文章于 2024-07-16 14:26:58 发布

最新推荐文章于 2024-07-16 14:26:58 发布 · 104 阅读

文章标签：

#MySQL #Perl #Socket #Access #UP

database 专栏收录该内容

7 篇文章

订阅专栏

本文详细记录了在CentOS 5.2环境下通过在线方式安装MySQL 5.0.45的过程，包括依赖包的自动处理及启动服务、设置密码等关键步骤。

新装了个centos5.2，忍不住要体验体验，mysql的安装方式为在线安装。前提当然是需要连上www。打开终端输入：

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

在线安装开始：

Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.i386 0:5.0.45-7.el5 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-server
--> Processing Dependency: perl-DBI for package: mysql-server
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Processing Dependency: perl(DBI) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-server
--> Processing Dependency: mysql = 5.0.45-7.el5 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.15 for package: mysql-server
--> Running transaction check
---> Package perl-DBD-MySQL.i386 0:3.0007-1.fc6 set to be updated
---> Package perl-DBI.i386 0:1.52-1.fc6 set to be updated
---> Package mysql.i386 0:5.0.45-7.el5 set to be updated
--> Finished Dependency Resolution
...........................
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing: perl-DBI                     ######################### [1/4]
  Installing: mysql                        ######################### [2/4]
  Installing: perl-DBD-MySQL               ######################### [3/4]
  Installing: mysql-server                 ######################### [4/4]
Installed: mysql-server.i386 0:5.0.45-7.el5
Dependency Installed: mysql.i386 0:5.0.45-7.el5 perl-DBD-MySQL.i386 0:3.0007-1.fc6 perl-DBI.i386 0:1.52-1.fc6
Complete!

安装成功，登录：

[root@localhost ~]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
You have mail in /var/spool/mail/root

对了，mysqld没有启动，启动：

[root@localhost ~]# service mysqld start

服务启动。再登录：

[root@localhost ~]# mysql -u root -p123
ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES)

没有设置root的默认密码，设个密码先：

[root@localhost ~]# cd /usr/bin/
[root@localhost bin]# mysqladmin -u root -h localhost password ‘123′

ok，再次登录：

[root@localhost bin]# mysql -u root -p123
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.45 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

OH,mygod，终于ok了