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@stmysql1 lib]# service mysql start
修改密码
/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 |
+------------------
安装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%]
[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
修改密码
/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 |
+------------------
- RHEL下安装mysql 5.5
- rhel linux下mysql安装
- rhel linux 安装MySQL
- 在 RHEL 5.5 下安装 Oracle RAC
- 在 RHEL 5.5 下安装 Oracle RAC
- rhel下安装gcc
- RHEL下安装openldap
- rhel下安装hg
- RHEL下安装ffmpeg
- VMware下RHEL配置网络、安装JDK和MySQL
- RHEL下架设MYSQL集群
- RHEL下架设MYSQL集群
- RHEL下MySQL错误处理
- rhel.5.0 下安装GCC
- rhel 6下安装VMwareTools
- RHEL 5 下安装gcc
- rhel.5.0 下安装GCC
- RHEL 5下iSCSI 安装
- C语言中的const,volatile与restrict的使用
- Oracle 数据泵的使用(1)
- CRC原理与计算
- 关于子类重写父类私有虚函数
- maven 编译hadoop错误解决
- RHEL下安装mysql 5.5
- UIWebView / NSURL / NSBoundle 相关应用 (实例,加载完成前的背景, 默认safari打开链接地址等)
- 50A_Domino piling
- equals()和hashcode()用法
- 网易视频播放器
- 素数判定
- ubuntu 安装maven
- HDU 3221 Brute-force Algorithm(矩阵求fibnacci,指数取模)
- windows 核心编程之18 堆