mysql rpm 方式安装及常见配置

通过filezilla 工具上次将mysql上传到虚拟机中 ，如图

通过rpm -ivh --replacefiles MySQL-server-5.5.28-linux2.6.x86_64.rpm 命令进行安装，先安装server

在安装client

启动mysql服务：service mysql start

Text-to-HTML conversion tool

使用命令ps -ef | grep mysql 查看mysql进程：

[root@localhost ~]# ps -ef|grep mysql root 3708 3057 0 18:39 pts/1 00:00:00 grep mysql

第一次登陆设置root密码：

mysql -u root -p 设置

设置root密码：

mysql> use mysql
Database changed
mysql> update user set password=password(‘root’) where user=‘root’;
Query OK, 0 rows affected (0.15 sec)
Rows matched: 5 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
退出，重新登陆即可使用新的密码登陆；

设置远程登陆：

使用root登陆到mysql后
切换到mysql数据库
mysql> show databases;

mysql> update user set host=’%’ where user=‘root’;

mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

mysql> update user set host=’%’ where user=‘root’;

mysql> select host,user from user;

然后：
mysql> grant all privileges on . to ‘root’@’@’ with grant option;

mysql> grant all privileges on . to ‘root’@’%’ with grant option;

mysql> exit
Bye
[root@localhost ~]# service mysql restart
Shutting down MySQL… SUCCESS!
Starting MySQL… SUCCESS!
重启mysql即可远程登陆。

停止mysql 服务