MySQL安装部署

mkdir /data
chown -R mysql:mysql   /data
cd
mv mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz /data/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

mkdir -p /software/mysql
chown -R mysql:mysql /software
cd /software/mysql
tar zxvf /data/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

cd /usr/local/
unlink mysql
ln -s /software/mysql-5.7.30-linux-glibc2.12-x86_64 mysql
chown -R mysql:mysql mysql

mkdir /data/mysql
mkdir /data/mysql/mysql_3306
cd /data/mysql/mysql_3306/
mkdir data
mkdir logs
mkdir tmp
chown -R mysql:mysql /data/mysql/mysql_3306

vi /etc/my.cnf

[client]
port = 3306
socket = /tmp/mysql3306.sock

[mysql]
#prompt="(u:HOSTNAME:)[d]> "
prompt="u@h R:m:s [d]> "
no-auto-rehash

[mysqld]
user = mysql
port = 3306
socket = /tmp/mysql3306.sock
basedir = /usr/local/mysql
datadir = /data/mysql/mysql_3306/data
character-set-server = utf8
back_log = 103
slow_query_log = 1
slow_query_log_file = /data/mysql/mysql_3306/data/slow.log
log-error = /data/mysql/mysql_3306/data/error.log
long_query_time = 0.1
server-id = 813306
log-bin = /data/mysql/mysql_3306/logs/log-bin
sync_binlog = 1
binlog_cache_size = 4M
binlog_format = row
relay_log_recovery = 1

transaction_isolation = REPEATABLE-READ
#innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 5734M
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_data_file_path = ibdata1:1024M;ibdata2:1024M;ibdata3:1024M:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 16M
innodb_log_file_size = 2G
innodb_log_files_in_group = 2
innodb_rollback_on_timeout = 1
innodb_print_all_deadlocks = 1
innodb_file_per_table = 1
innodb_locks_unsafe_for_binlog = 0


cd /usr/local/mysql
./bin/mysqld --initialize-insecure

cd /usr/local/mysql
[root@master01 mysql]# pwd
/usr/local/mysql

[root@master01 mysql]#
[root@master01 mysql]# <+++++++++++++无任何回显

[root@Mysql01 mysql]# ./bin/mysqld --initialize-insecure
#–initialize-insecure，不需要密码即可进入

[root@Mysql01 mysql]# ./bin/mysqld --initialize
./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
[root@Mysql01 mysql]#
[root@Mysql01 mysql]#

[root@Mysql01 mysql]# yum -y install libaio.x86_64
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
base | 3.6 kB 00:00:00
epel | 5.3 kB 00:00:00
extras | 3.4 kB 00:00:00
updates | 3.4 kB 00:00:00
(1/2): epel/x86_64/updateinfo | 973 kB 00:00:00
(2/2): epel/x86_64/primary_db | 6.7 MB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================================================================================================================================================
Package Arch Version Repository Size
=================================================================================================================================================================================================================================
Installing:
libaio x86_64 0.3.109-13.el7 base 24 k

Transaction Summary
=================================================================================================================================================================================================================================
Install 1 Package

Total download size: 24 k
Installed size: 38 k
Downloading packages:
libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : libaio-0.3.109-13.el7.x86_64 1/1
Verifying : libaio-0.3.109-13.el7.x86_64 1/1

Installed:
libaio.x86_64 0:0.3.109-13.el7

Complete!
[root@Mysql01 mysql]#
[root@Mysql01 mysql]#
[root@Mysql01 mysql]#

cd /usr/local/mysql
cp support-files/mysql.server /etc/init.d/mysql
echo "export PATH=$PATH:/usr/local/mysql/bin">>/etc/profile
source /etc/profile



====
[root@master01 ~]# chkconfig --list
Note: This output shows SysV services only and does not include native
systemd services. SysV configuration data might be overridden by native
systemd configuration.
If you want to list systemd services use systemctl list-unit-files.
To see services enabled on particular target use
systemctl list-dependencies [target].
netconsole 0:off 1:off 2:off 3:off 4:off 5:off 6:off
network 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@master01 ~]# chkconfig --add mysql.server
error reading information on service mysql.server: No such file or directory
[root@master01 ~]#
[root@master01 ~]#
[root@master01 ~]# chkconfig --add mysql
[root@master01 ~]# chkconfig --list
Note: This output shows SysV services only and does not include native
systemd services. SysV configuration data might be overridden by native
systemd configuration.
If you want to list systemd services use systemctl list-unit-files.
To see services enabled on particular target use
systemctl list-dependencies [target].
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
netconsole 0:off 1:off 2:off 3:off 4:off 5:off 6:off
network 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@master01 ~]#

=====

service mysql start |stop|restart

cat /data/mysql/mysql_3306/data/error.log |grep "password"

2017-11-01T07:31:33.932297Z 1 [Note] A temporary password is generated for root@localhost: XX41vxuK;=!q

mysql -S /tmp/mysql3306.sock -uroot -p

alter user root@localhost identified by abcd1234;
flush privileges;