在Linux Centos 6.7环境下,通过yum安装mysql。
1、使用yum安装mysql
yum list | grep mysql
yum install mysql-server.x86_64
yum install mysql.x86_64
2、查看mysql版本
rpm -qi mysql-server
3、重启<span style="font-family: 'Times New Roman';">mysql</span>
service mysqld restart
4、查看是否开机启动mysql
chkconfig --list | grep mysqld
[root@localhost Desktop]# chkconfig --list | grep mysqld
mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
5、设置mysql开机启动
chkconfig mysqld on
chkconfig --list | grep mysqld
[root@localhost Desktop]# chkconfig mysqld on
[root@localhost Desktop]# chkconfig --list | grep mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
6、修改mysql用户密码
修改用户root的密码为root
/usr/bin/mysqladmin -u root password 'root'
[root@localhost Desktop]# /usr/bin/mysqladmin -u root password 'root'
7、用root用户登录mysql
mysql -u root -p
[root@localhost Desktop]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.73 Source distribution
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>
8、允许root用户远程登录连接
允许root用户在任何地方进行远程登录,并具有所有库任何操作权限
命令行:
[root@localhost Desktop]# mysql -u root -p"root"
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES
9、连接mysql导入SQL脚本
将SQL脚本上传到tmp目录下。
mysql -u root -p
create database test;
use test;
source /tmp/test.sql;
[root@centos6 /]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.73 Source distribution
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> create database test;
mysql> use test;
Database changed
mysql> source /tmp/test.sql;