Linux系统安装MySql5.1

下载 MySQL-server-community-5.1.51-1.rhel5.i386    MySQL-client-community-5.1.51-1.rhel5.i386

安装Mysql

# rpm -ivh MySQL-server-community-5.1.51-1.rhel5.i386.rpm MySQL-client-community-5.1.51-1.rhel5.i386.rpm
Preparing...                ########################################### [100%]
   1:MySQL-client-community ########################################### [ 50%]
   2:MySQL-server-community ########################################### [100%]
 
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 kevin 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.
 
Please report any problems with the /usr/bin/mysqlbug script!
 
Starting MySQL.
Giving mysqld 2 seconds to start

到这里已经安装好了，输入mysql测试一下正常了

mysql默认安装没有密码了
设置root密码

#cd /usr/bin
#./mysqladmin -u root password 123456

这次测试，输入mysql 将会被拒绝，要输入mysql -uroot -p 回车输入密码即可成功登录了。

再把mysql做到服务中随服务器启动
先查看mysql是否在服务列表中#chkconfig --list
如果没有则要先加入list #chkconfig --add mysql
自启动 #chkconfig mysql on

评论

4 楼 zixiaolan 2010-10-20  

hsys 写道

zixiaolan 写道

localhost.localdomain

这个东东没找到，是不是跟我网络配置，主机配置有关系

首先看看你的mysql是否安装好了，输入mysql测试一下，到/usr/bin下看看是否有mysqladmin 也可以用find命令查找，运行./mysqladmin -u root password '123456'

谢谢兄弟，用你的方法装好了

3 楼 hsys 2010-10-18  

zixiaolan 写道

localhost.localdomain

这个东东没找到，是不是跟我网络配置，主机配置有关系

首先看看你的mysql是否安装好了，输入mysql测试一下，到/usr/bin下看看是否有mysqladmin 也可以用find命令查找，运行./mysqladmin -u root password '123456'

2 楼 zixiaolan 2010-10-18  

localhost.localdomain

这个东东没找到，是不是跟我网络配置，主机配置有关系

1 楼 zixiaolan 2010-10-18  

兄弟在么?
我的按照你的安装方式安装，出现了个问题，
前的界面都是一致的，如下

[root@localhost setupall]# rpm -ivh  MySQL-server-5.1.51-1.glibc23.i386.rpm  MySQL-client-5.1.51-1.glibc23.i386.rpm                                                     warning: MySQL-server-5.1.51-1.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-client           ########################################### [ 50%]
   2:MySQL-server           ########################################### [100%]

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'

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.

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


----------------
然后按照提示修改密码
输入  /usr/bin/mysqladmin -u root password ‘1234356’
报错
提示：
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'xiaoxiao'
/usr/bin/mysqladmin: connect to server at 'localhost.localdomain' failed