1. 安装MySQL服务
#查询是否安装mysql-server,示例中并未安装 rpm -qa | grep mysql mysql-devel-5.1.52-1.el6_0.1.x86_64 mysql-5.1.52-1.el6_0.1.x86_64 mysql-libs-5.1.52-1.el6_0.1.x86_64 #使用 yum -y install mysql-server安装 yum -y install mysql-server #设置mysql-server开机自启动 chkconfig mysqld on #可检查是否设置成功(2、3、4、5项为on即设置正常) chkconfig --list | grep mysqld mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
2. 启动MySQL服务
#以服务名方式启动 service mysqld start #从文件启动MySql服务 c.d/init.d/mysqld start
3. 配置MySQL
#默认root密码为空 mysql -u root #可查询用户信息 select user,host,password from mysql.user; mysql> select user,host,password from mysql.user; +------+------------+----------+ | user | host | password | +------+------------+----------+ | root | localhost | | | root | crxj-app-1 | | | root | 127.0.0.1 | | | | localhost | | | | crxj-app-1 | | +------+------------+----------+ 5 rows in set (0.00 sec) #设置root用户密码 SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourRootPwd'); #使用exit退出,使用新密码登录 exit mysql -uroot -p #可以查看默认包含的数据库 mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.00 sec)
至此完成所有MySQL安装配置工作
转载请标明作者和原文链接。
ifuteng#gmail.com 2014/6/23 16:24