CentOS6.7 Mysql5.6.35 version source code compilation + Mysql database forget how to change root password
Source code compilation MySQL
[root@CentOS61 ~] # yum install cmake nucrses-devel-y / / install the development package for compiling environment and terminal operation
……
Installed:
Cmake.x86_64 0VOR 2.8.12.2-4.el6
Dependency Installed:
Libarchive.x86_64 0VOR 2.8.3-7.el6_8
Complete!
Download the software package
[root@CentOS61 ~] # wget http://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.6/mysql-5.6.35.tar.gz
.
32167628 24.0K/s in 2.2s
2017-04-12 22:23:19 (24.0 KB/s)-"mysql-5.6.35.tar.gz" saved [32167628]
Note: if the command is slow to download, you can download it using windows and then upload it to linux.
Decompression
[root@CentOS61 ~] # tar-xf mysql-5.6.35.tar.gz-C / usr/local/src/-C specify the decompression directory
[root@CentOS61 ~] # ls / usr/local/src/
Mysql-5.6.35
Check whether the mysql user exists
[root@CentOS61 ~] # grep mysql / etc/passwd
Create a user
[root@CentOS61] # useradd-u 8001-s / sbin/nologin mysql
Create a database directory
[root@CentOS61 ~] # mkdir / data
Enter the directory to compile and install
[root@CentOS61 ~] # cd / usr/local/src/mysql-5.6.35/
[root@CentOS61 mysql-5.6.35] # cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_UNIX_ADDR=/tmp/mysql.sock-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS=all-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DENABLED_LOCAL_INFILE=1-DMYSQL_DATADIR=/data-DMYSQL_USER=mysql
Start compilation and installation
[root@CentOS61 mysql-5.6.35] # make-j 4 & & make install
Use $at the end? Check to see if it is successful
[root@CentOS61 mysql-5.6.35] # echo $?
0
User authorization
[root@CentOS61 mysql-5.6.35] # chown-R mysql:mysql / usr/local/mysql
[root@CentOS61 mysql-5.6.35] # chown-R mysql:mysql / data
[root@CentOS61 mysql-5.6.35] # chmod 1777 / tmp/
Create a profile
Overwrite existing configuration files
[root@CentOS61 mysql-5.6.35] # cp / usr/local/mysql/support-files/my-default.cnf / etc/my.cnf
Cp: overwrite `/ etc/my.cnf'? Y
Set environment variabl
[root@CentOS61 mysql-5.6.35] # echo 'export PATH=/usr/local/mysql/bin:$PATH' > > / etc/profile
[root@CentOS61 mysql-5.6.35] # source! $/ / effective file
Source / etc/profile
Create a service startup script
[root@CentOS61 mysql-5.6.35] # cp / usr/local/mysql/support-files/mysql.server / etc/init.d/mysqld / / copy startup script and rename it to mysqld
[root@CentOS61 mysql-5.6.35] # chmod + x! $
Chmod + x / etc/init.d/mysqld / / Grant script execution permission
[root@CentOS61 ~] # vim / etc/init.d/mysqld
Modify
46 basedir=
47 datadir=
For
46 basedir=/usr/local/mysql
47 datadir=/data
Set Boot self-boot
[root@CentOS61 ~] # chkconfig mysqld on / / set boot self-startup
Initialize the database
[root@CentOS61 ~] # chmod + x / usr/local/mysql/scripts/mysql_install_db / / add execution permissions to the directory
[root@CentOS61 ~] # / usr/local/mysql/scripts/mysql_install_db-- defaults-file=/etc/my.cnf-- basedir=/usr/local/mysql/-- datadir=/data/-- user=mysql / / specify configuration file, directory, user (it will take some time)
Initialize the security configuration
[root@CentOS61 ~] # service mysqld start / / start the service
Starting MySQL.Logging to'/ data/CentOS61.err'.
. SUCCESS!
Note: it will take a few minutes. It may be the version of the database.
[root@CentOS61 ~] # service mysqld status / / View service status
SUCCESS! MySQL running (16856)
[root@CentOS61 ~] # mysql_secure_installation
……
Enter current password for root (enter for none): / / A password is required. Enter directly without a password.
……
Set root password? [Ymen] Y / / prompt to set the root password
New password: / / enter the password 123456 to be set (shown in ciphertext)
Re-enter new password: / / repeat confirmation of password
……
Remove anonymous users? [YPop] y / / whether to delete anonymous users (anonymous users can log in to the server and need to be deleted)
.
Disallow root login remotely? [Yopin] Y / / prohibit root users from logging in remotely
……
Remove test database and access to it? [YBO] Y / / Delete the test database (once the database is created, the test database is useless)
……
Reload privilege tables now? [YPo] Y / / refresh the list of databases
Log into the database
[root@CentOS61] # mysql-u root-p123456 / / Log in to the database
Mysql > show engines; / / View default engine
+-- +
| | Engine | Support | Comment | Transactions | XA | Savepoints | |
+-- +
| | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | |
| | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | |
| | MyISAM | YES | MyISAM storage engine | NO | NO | NO | |
| | BLACKHOLE | YES | / dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| | CSV | YES | CSV storage engine | NO | NO | NO | |
| | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| | ARCHIVE | YES | Archive storage engine | NO | NO | NO | |
| | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | |
+-- +
9 rows in set (0.00 sec)
Install MySQL Complete
Mysql database forgot how to change root password
Environment: CentOS6.7 Mysql5.6.35 version of Mysql database forgot how to change root password
Log in to the Mysql database and forget your password
[root@CentOS61 ~] # mysql-V / / View mysql version
Mysql Ver 14.14 Distrib 5.6.35, for Linux (x86 / 64) using EditLine wrapper
[root@CentOS61 ~] # mysql-uroot-p / / Log in to the database
Enter password: / / forget your password
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Change root password 1, stop mysql service
[root@CentOS61 ~] # service mysqld stop
Shutting down MySQL.. SUCCESS!
2. Enter skip-grant-tables mode
[root@CentOS61] # mysqld_safe-- skip-grant-tables
170413 01:51:11 mysqld_safe Logging to'/ data/CentOS61.err'.
170413 01:51:11 mysqld_safe Starting mysqld daemon with databases from / data
Ctrl+z terminates after resetting the root password
[1] + Stopped mysqld_safe-- skip-grant-tables
Open a new window to log in to the database, you can skip password authentication
[root@CentOS61 ~] # mysql / / directly enter the database
Mysql > use mysql / / enter mysql database
Mysql > update user set password=password ("1234567") where user= "root"; / / modify root password
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
Mysql > flush privileges; / / refresh permissions
Query OK, 0 rows affected (0.01 sec)
Mysql > exit / / exit the database
[root@CentOS61 ~] # pkill mysql / / stop mysql database
[root@CentOS61 ~] # service mysqld start
Starting MySQL.. SUCCESS!
[root@CentOS61 ~] # mysql-uroot-p1234567 / / log in to the database with a new password
Root password modified successfully
