Linux服务器安装数据库

来源：互联网发布：知锦教育龙腾编辑：程序博客网时间：2024/06/06 03:18

1、查看linux系统中是否安装了mysql 执行：rpm -qa|grep -i mysql 如有会显示已安装的Mysql版本,我的显示mysql-libs-5.1.61-4.el6.i686

2、这时如果有的话就强制删除：rpm -e --nodeps mysql-libs-5.1.61-4.el6.i686（因为有包依赖，所以要强制删除）

3、下载mysql

wget http://cdn.mysql.com/archives/mysql-5.6/MySQL-client-5.6.15-1.el6.x86_64.rpm
wget http://cdn.mysql.com/archives/mysql-5.6/MySQL-devel-5.6.15-1.el6.x86_64.rpm
wget http://cdn.mysql.com/archives/mysql-5.6/MySQL-server-5.6.15-1.el6.x86_64.rpm

4、安装数据库

rpm -ivh MySQL-server-5.6.15-1.el6.x86_64.rpm

rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm

5、进入数据库修改密码

按照以下顺序执行

# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

安装成功

0 0