linux安装mysql教程，

1.从官网现在包，

2.上传包到 linux上面 位置、usr/local

3.解压压缩包

tar -zxf mysql-5.6.42-linux-glibc2.12-x86_64.tar.gz

4.重命名压缩包

mv mysql-5.6.42-linux-glibc2.12-x86_64 mysql

5.移动到mysql目录下

cd /usr/local/mysql

6.创建用户组

groupadd mysql

useradd -r -g mysql mysql

7.更改权限目录

chown -R mysql:mysql ./

8.安装libaio依赖（可以不安装，有可能出错，还是安装一下好）

yum install libaio

9.安装完之后修改当前目录拥有者为root用户，修改data目录拥有者为mysql

chown -R root:root ./

chown -R mysql:mysql data

10.进入scripts

cd scripts

11.安装mysql

./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

12.优化配置

cd /usr/local/mysql-5.6.27/support-filescp my-default.cnf /etc/my.cnf（修养修改my.cnf的配置，可以参照下面的配置来）

cp mysql.server /etc/init.d/mysqlvim /etc/init.d/mysql #若mysql的安装目录是/usr/local/mysql,则可省略此步修改文件中的两个变更值basedir=/usr/local/mysql-5.6.27datadir=/usr/local/mysql-5.6.27/data

 

13.配置环境变量

export MYSQL_HOME="/usr/local/mysql"

export PATH="​MYSQL_HOME/bin"

 

14.添加自启服务

chkconfig --add mysqlchkconfig mysql on 修改服务的默认启动等级

15.启动mysql

ps -ef|grep mysqld

启动： service mysql start

停止: service mysql stop

重启：service mysql restart

或者可以使用下面的命令停止MYSQL服务：mysqladmin -u root -p shutdown

 

16.修改mysql密码

mysqladmin -u root password '123456'

 

17.启动mysql

mysql -u root -p

123456

18.开放端口，远程连接mysql

vi /etc/sysconfig/iptables

添加文件

iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

重启端口

service iptables restart --重启防火墙

cnf 文件配置，注意修改文件路径

[client]
port = 3306
socket = /usr/local/mysql/data/mysql.sock
[mysqld]
bind-address = 0.0.0.0
port = 3306
socket = /usr/local/mysql/data/mysql.sock
pid-file =/usr/local/mysql/data/mysql.pid
character-set-server = utf8
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
​
skip-external-locking
skip-name-resolve
lower_case_table_names = 1
log-bin-trust-function-creators = 1
​
max_connections = 6000
max_user_connections = 6000
max_connect_errors = 4000
wait_timeout = 86400
interactive_timeout = 86400
table_open_cache = 512
max_allowed_packet = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 8
thread_concurrency = 8
query_cache_size = 32M
#default-storage-engine = InnoDB
​
#sql_mode="STRICT_ALL_TABLES,NO_AUTO_CREATE_USER"
server-id = 1
​
log-short-format
log-error = /usr/local/mysql/logs/mysql.log
slow_query_log
long_query_time = 2
slow_query_log_file = /usr/local/mysql/logs/mysql-slow.log
log_bin_trust_function_creators=1
binlog_format = MIXED
expire_logs_days = 10
​
​
# MyISAM Specific options
key_buffer_size = 384M
read_buffer_size = 4M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 1G
myisam_repair_threads = 1
myisam_recover
​
[mysqldump]
quick
max_allowed_packet = 16M
​
[mysql]
default-character-set = utf8
no-auto-rehash
socket = /usr/local/mysql/data/mysql.sock
​
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
​
[mysqlhotcopy]
interactive-timeout

问题1

不允许远程连接

is not allowed to connect mysql server

 

mysql -u root -p #登录mysql,需要输入密码

mysql>GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION; #允许root用户远程访问

mysql>FLUSH PRIVILEGES;

#刷新权限

这时候就可以远程连接了