1:检查linux系统是否安装mysql数据库
[root@localhost ~]# yum list installed mysql*
[root@localhost ~]# rpm -qa | grep mysql*
2:查看yum有没有安装包
[root@localhost ~]# yum list mysql*
3:安装MySQL客户端
[root@localhost ~]# yum install mysql
4:安装MySQL服务器端:
[root@localhost ~]# yum install mysql-server
[root@localhost ~]# yum install mysql-devel
5:设置MySQL数据库字符集
[root@localhost ~]# vi /etc/my.cnf
在文本最下方写入default-character-set=utf8
6:添加linux开机启动
[root@localhost ~]# chkconfig –add mysqld
[root@localhost ~]# chkconfig mysqld on
7:查看开机启动设置是否成功
[root@localhost ~]# chkconfig –list | grep mysql*
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
8:启动与关闭MySQL数据库
[root@localhost ~]# service mysqld start
查看MySQL是否启动
[root@localhost ~]# ps -ef|grep mysql
关闭MySQL数据库
[root@localhost ~]# service mysqld stop
9:登陆MySQL数据库
创建root管理员
[root@localhost ~]# mysqladmin -u root password 123456
登录:
[root@localhost ~]# mysql -u root -p
Enter password:
输入密码即可登录
10:卸载MySQL 数据库
[root@localhost ~]# yum -y remove mysql*
然后将 /var/lib/mysql文件夹下的所有文件都删除干净
[root@localhost ~]# cd /var/lib/mysql/
[root@localhost mysql]# rm -rf *
最后再重新执行上面的安装步骤。
11:设置MySQL远程登录
如果用户无法从本地登陆,这个时候就执行如下
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’localhost’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
mysql> flush privileges ;
设置用户任意远程地址登录
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
mysql> flush privileges ;