mysql tar centos7

vim /etc/my.cnf

[client]
port = 3306
socket=/ddhome/bin/mysql/tmp/mysql.sock

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
#skip-grant-tables
character_set_server=utf8
init_connect='SET NAMES utf8'
skip-name-resolve
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=/usr/local/mysql/
# 设置mysql数据库的数据的存放目录
datadir=/ddhome/bin/mysql/data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=16M
log-error=/ddhome/bin/mysql/log/mysqld.log
pid-file=/ddhome/bin/mysql/data/mysqld.pid
socket=/ddhome/bin/mysql/tmp/mysql.sock


rpm -qi mysql-server

rpm -qa | grep "mysql"


rpm -qa|grep mariadb

rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

rm /etc/my.cnf

rpm -qa | grep mysql

cat /etc/group | grep mysql

cat /etc/passwd | grep mysql

groupadd mysql
useradd -g mysql mysql

passwd mysql

#由于我的/usr/local空间不足，所以我安装到/var
[root@hdp265dnsnfs var]# tar -zxvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
[root@hdp265dnsnfs var]# mv mysql-5.7.18-linux-glibc2.5-x86_64/ mysql57

#更改所属的组和用户
chgrp -R mysql /usr/local/mysql/
chown -R mysql /usr/local/mysql/
cd /usr/local/mysql/
chown -R mysql:mysql /ddhome/bin/mysql/
chown -R mysql:mysql /ddhome/bin/mysql/data/

vim /etc/my.cnf


[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
basedir=/usr/local/mysql
datadir=/ddhome/bin/mysql/data
socket=/tmp/mysql.sock
#不区分大小写 (sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 这个简单来说就是sql语句是否严格)
lower_case_table_names = 1
log-error=/ddhome/bin/mysql/log/mysqld.log
pid-file=/ddhome/bin/mysql/data/mysqld.pid



[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
skip-name-resolve
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=/usr/local/mysql/ 
# 设置mysql数据库的数据的存放目录
datadir=/ddhome/bin/mysql/data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=16M

chmod 777 /ddhome/bin/mysql/

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/ddhome/bin/mysql/tmp/mysql.sock' (2)

chown -R mysql:mysql /usr/local/mysql/
chown -R mysql:mysql /ddhome/bin/mysql/

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
vim /etc/my.cnf

skip-grant-tables
mysql -u root mysql
UPDATE user SET Password=PASSWORD('dd@2018') where USER='root';
update user set authentication_string=PASSWORD("dd@2018") where user='root';
ps -ef | grep mysqld

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
alter user 'root'@'localhost' identified by 'root';



cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysqld

vim /etc/init.d/mysqld

service mysqld start

chkconfig --add mysqld

chkconfig  mysqld on

ln -s /usr/local/mysql/bin/mysql /usr/bin

cat /root/.mysql_secret



mysqladmin -u root -p

mysql -uroot -p

update user set authentication_string=PASSWORD("dd@2018") where user='root';


alter user 'root'@'localhost' identified by 'root';

flush privileges;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'dd@2018' WITH GRANT OPTION;

mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/ddhome/bin/mysql/data/


mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/ddhome/bin/mysql/data/

mysql_ssl_rsa_setup --datadir=/ddhome/bin/mysql/data/



cp ./support-files/mysql.server /etc/init.d/mysqld
chown 777 /etc/my.cnf
chmod +x /etc/init.d/mysqld
/etc/init.d/mysqld restart
chkconfig --level 35 mysqld on
chkconfig --list mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --list mysqld
service mysqld status

export PATH=$PATH:/usr/local/mysql/bin


SET PASSWORD FOR 'root'@'localhost' = PASSWORD('dd@2018');


1、安装mysql
　　wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz #下载mysql
　　tar zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz #解压mysql文件
　　cp mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/mysql -r #复制解压后的mysql目录到系统的本地软件目录
　　groupadd mysql #创建mysql组
　　useradd mysql -g mysql #创建mysql用户并添加到mysql用户组
　　pwd #当前目录 /usr/local/mysql
　　chown -R mysql . #修改mysql所属用户
　　chgrp -R mysql . #修改mysql所属组
　　cd /usr/local/mysql/bin
　　yum install libaio
　　./mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/ddhome/bin/mysql/data #data目录没有就创建(用mysql用户)，另外mysql_install_db这个命令已经废了换成了mysqld
　　ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql #创建mysql快捷方式
　　service mysql start #启动mysql服务
　　service mysql stop #停止mysql服务
　　service mysql restart #重启mysql服务
　　netstat -anp|grep mysqld #查看mysql服务
mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/ddhome/bin/mysql/data

2、接下来就是登陆了
　　因为是首次登陆，这里笔者使用的方式是
　　cat /root/.mysql_secret #这个是root首次登陆mysql的初始密码
　　mysql -uroot -p密码
　　SET PASSWORD FOR 'root'@'localhost' = PASSWORD('dd@2018');   #修改数据密码　　
   GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "dd@2018";
3、设置远程客户端登陆
　　mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.0' IDENTIFIED BY '123456' WITH GRANT OPTION;
　　mysql>FLUSH PRIVILEGES;

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm