Mysql5.6.22 compile, install, and log on Display error showdatabases prompt show not found command? If the secure mode logon is enabled in centos 7.0, you cannot directly execute mysql_secure_installation. the system prompts that you have enabled skip permission verification and do not need to set a new mysql password.
Error message
The password must not be blank. which one cannot be connected?
The execution of mysqlshow is also normal.
This is my manual compilation process.
Http://www.cnblogs.com/xxx91hx/p/4256519.html
Where is the error ~ Please give me some advice ~
I have been searching for it for several days ......
I re-compiled it several times. I don't know what went wrong ~
Reply to discussion (solution)
Show databases; it's a mysql statement. it's not a command. you failed to enable mysql.
Show databases; it's a mysql statement. it's not a command. you failed to enable mysql.
That's the mysql command. I'm running all mysql processes now.
Also, can I query if the root user table has a password and generate a random password by default?
[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
The bold one is wrong. how can it be changed? it has already been re-compiled several times? could you please help me ~ Don't go. it's been several days ~ I checked the 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
13:07:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use -- explicit_defaults_for_timestamp server option (see documentation for more details ).
13:07:20 2818 [Note] Plugin 'Federated 'is disabled.
13:07:20 2818 [Note] InnoDB: Using atomics to ref count buffer pool pages
13:07:20 2818 [Note] InnoDB: The InnoDB memory heap is disabled
13:07:20 2818 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
13:07:20 2818 [Note] InnoDB: Memory barrier is not used
13:07:20 2818 [Note] InnoDB: Compressed tables use zlib 1.2.3
13:07:20 2818 [Note] InnoDB: Not using CPU crc32 instructions
13:07:20 2818 [Note] InnoDB: Initializing buffer pool, size = 128.0 M
13:07:20 2818 [Note] InnoDB: Completed initialization of buffer pool
13:07:20 2818 [Note] InnoDB: Highest supported file format is Barracuda.
13:07:20 2818 [Note] InnoDB: 128 rollback segment (s) are active.
13:07:20 2818 [Note] InnoDB: Waiting for purge to start
13:07:20 2818 [Note] InnoDB: 5.6.22 started; log sequence number 1626363
13:07:20 2818 [Note] Server hostname (bind-address): '*'; port: 3306
13:07:20 2818 [Note] IPv6 is available.
13:07:20 2818 [Note]-': 'resolves '::';
13:07:20 2818 [Note] Server socket created on IP :'::'.
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
Isn't there similar logs in the link you provided? Do you follow these steps in sequence?
Isn't there similar logs in the link you provided? Do you follow these steps in sequence?
I re-installed it, and the password is empty.
However, logon is still unavailable.
The logs all show localhost. localdomain. err. this is the above error.
Could you give me some advice on how to solve the mistakes in the processes I wrote ~
Isn't there similar logs in the link you provided? Do you follow these steps in sequence?
I re-installed it, and the password is empty.
However, logon is still unavailable.
The logs all show localhost. localdomain. err. this is the above error.
Could you give me some advice on how to solve the mistakes in the processes I wrote ~
Paste your mysql configuration file, which should be a problem with your configuration.
Do you use show databases in [root @ localhost bin?
I have no idea what environment I am in?
Do you use show databases in [root @ localhost bin?
I have no idea what environment I am in?
Thanks to the answers provided by the moderator. I know that mysql is no longer used, but I don't know what is wrong. The last reason is that the cmake cache compilation file is not deleted. thank you very much for your answers ~ Solved by yourself ~
