Install in CentOS 7.0 enable Safe Mode login or not direct execution mysql_secure_installation prompt has turned on Skip permission verification does not need to set MySQL new password
Error message
The password must not be empty.
Mysqlshow execution also shows up normally.
This is my manual compilation process.
Http://www.cnblogs.com/xxx91hx/p/4256519.html
What the hell is wrong ~ Ask the big God to guide ha ~
Looked for several days have been looking for a long time ...
It's been recompiled several times and I don't know where it went wrong ~
Reply to discussion (solution)
show databases; It's a MySQL statement, not a command, you failed when you started MySQL.
show databases; It's a MySQL statement, not a command, you failed when you started MySQL.
Great God, yes, that's the MySQL command, and now I'm up to the MySQL process.
And I query the user table root already has the password, default generate random password?
[Root@localhost bin]# mysql-e "Select Host,user,password from User" MySQL
+-----------+------+-------------------------------------------+
| Host | User | Password |
+-----------+------+-------------------------------------------+
| localhost | Root | *e12314f6f61024e3fc91cbebc75b7e1427e66efa |
| 127.0.0.1 | Root | *e12314f6f61024e3fc91cbebc75b7e1427e66efa |
| :: 1 | Root | *e12314f6f61024e3fc91cbebc75b7e1427e66efa |
+-----------+------+-------------------------------------------+
This is the information in the error log.
Error message
Bold is wrong How to change has been several times to recompile to ask God to help see ~ Big God don't go for a few days ~ old check information ....
150209 13:07:06 mysqld_safe mysqld from PID File/usr/etc/mysql/data/localhost.localdomain.pid ended
150209 13:07:20 Mysqld_safe starting mysqld daemon with databases From/usr/etc/mysql/data
2015-02-09 13:07:20 0 [Warning] TIMESTAMP with implicit the DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-02-09 13:07:20 2818 [Note] Plugin ' federated ' is disabled.
2015-02-09 13:07:20 2818 [Note] innodb:using Atomics to ref count buffer pool pages
2015-02-09 13:07:20 2818 [Note] innodb:the InnoDB memory heap is disabled
2015-02-09 13:07:20 2818 [Note] innodb:mutexes and rw_locks use GCC atomic builtins
2015-02-09 13:07:20 2818 [Note] innodb:memory barrier is not used
2015-02-09 13:07:20 2818 [Note] innodb:compressed tables use zlib 1.2.3
2015-02-09 13:07:20 2818 [Note] innodb:not using CPU CRC32 instructions
2015-02-09 13:07:20 2818 [Note] innodb:initializing buffer pool, size = 128.0M
2015-02-09 13:07:20 2818 [Note] innodb:completed initialization of buffer pool
2015-02-09 13:07:20 2818 [Note] innodb:highest supported file format is Barracuda.
2015-02-09 13:07:20 2818 [Note] innodb:128 rollback segment (s) is active.
2015-02-09 13:07:20 2818 [Note] innodb:waiting for purge to start
2015-02-09 13:07:20 2818 [Note] innodb:5.6.22 started; Log sequence Number 1626363
2015-02-09 13:07:20 2818 [Note] Server hostname (bind-address): ' * '; port:3306
2015-02-09 13:07:20 2818 [Note] IPv6 is available.
2015-02-09 13:07:20 2818 [note]-':: ' resolves to ':: ';
2015-02-09 13:07:20 2818 [Note] Server socket created on IP: ':: '.
2015-02-09 13:07:20 2818 [Note]/usr/etc/mysql/bin/mysqld:ready for connections.
Version: ' 5.6.22 ' socket: '/usr/etc/mysql/mysqld.sock ' port:3306 Source distribution
Is there a similar log in the link you provided? Do you follow the steps in the sequence?
Is there a similar log in the link you provided? Do you follow the steps in the sequence?
I put it back on again, and the password is empty.
But login or not
The logs are all localhost.localdomain.err, and this is the error above.
Ask the Great God to help guide the idea how to solve the process I wrote the wrong thing ~
Is there a similar log in the link you provided? Do you follow the steps in the sequence?
I put it back on again, and the password is empty.
But login or not
The logs are all localhost.localdomain.err, and this is the error above.
Ask the Great God to help guide the idea how to solve the process I wrote the wrong thing ~
Post your MySQL configuration file, it should be your configuration problems
Do you use show databases under [Root@localhost bin]?
You don't know where you are?
Do you use show databases under [Root@localhost bin]?
You don't know where you are?
Thank you for the moderator's answer I know it's no longer MySQL, but I don't know what's wrong. The last is because not deleted CMake cache compiled files caused by the very grateful answer ~ self-solved ~
