RHEL下安装mysql 5.5

来源:互联网 发布:nginx filter 编辑:程序博客网 时间:2024/05/16 08:18
具体版本为:rhel 5.8  + mysql 5.5.33版本
安装mysql比安装oracle简单的多,只需下载rpm直接安装就可以了
1,在linux平台,最简单的就是直接下载并安装rpm软件包,一般安装server和client两个软件包


[root@stmysql1 tmp]# rpm -Uvh MySQL-server-5.5.33-1.rhel5.x86_64.rpm
Preparing...                ########################################### [100%]
   1: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 stmysql1 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!

[root@linux1 tmp]# rpm -Uvh MySQL-client-5.5.33-1.rhel5.x86_64.rpm
Preparing...                ########################################### [100%]
   1:MySQL-client           ########################################### [100%]


2,启动mysql
[root@stmysql1 lib]# service mysql start

Starting MySQL..[  OK  ]

此时mysql已经默认设置为自动启动了,如果没有,可以手工设置

[root@stmysql1 mysql]# chkconfig --list mysql
mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off

3,为了安全设置,可以设置root口令和其它安全设置
修改密码
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h stmysql1 password 'new-password'

4,登录数据库验证安装情况
-bash-3.2$ mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.5.33 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| mytest             |
| performance_schema |
+------------------

原创粉丝点击