They are the same software. The -log
suffix is simply appended to the version string at runtime.
Here's an explanation (nearly from the last century), by long-time MySQL author Paul DuBois:
I want to know what the -log means and how it got in there.
-log is added if you start the server with logging turned on.
-debug is added if you're running a debugging version of the server with debugging on.
-demo is added if the server is running in demo mode
I verified this in the source, in sql/mysqld.cc
, function set_server_version()
:
. . .
if (opt_log || opt_slow_log || opt_bin_log)
strmov(end, "-log"); // This may slow down system
. . .
I think the meaning of that comment is not that appending four extra characters to the version slows down the system, but that logging may slow down the system, so it's worth noting to the DBA that logging is enabled.
Since you started mysqld
with --skip-grant-tables, you cannot execute any standard GRANT, REVOKE, or SET PASSWORD commands. Notwithstanding, you can change the password of root@localhost
as follows:
UPDATE mysql.user SET password=PASSWORD(‘passhere') WHERE user='root' and host='localhost';
Then, restart mysqld and you are back in business.
As to you being anonymous, if you login right now and run
SELECT USER() HowYouAttemptedToLogin,CURRENT_USER() HowYouWereAllowedToLogin;
You will note that the HowYouWereAllowedToLogin
will have an blank username and some host.
GIVE IT A TRY !!!
UPDATE 2015-11-17 16:24 EST
The column known as password
in mysql.user
no longer exists in MySQL 5.7.
It was renamed authentication_string
.
Proper Approach
What you should have done is run
mysqld --initialize
That would create the data folder for you.
The root@localhost was assigned a temporary password, which is visible in the error file starting with the following datetime and string
2015-11-17T20:56:02.175980Z 1 [Note] A temporary password is generated for root@localhost:
You could log in with it and then run ALTER USER
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
See the MySQL 5.7 Documentation on SET PASSWORD
Best Answer
It looks like
mysql-community-server-5.7.9-1.el7.x86_64.rpm
includes the following additional features (list may not included all) that are not available in themysql-community-server-minimal-5.7.9-1.el7.x86_64.rpm
:myisam_ftdump
myisamlog — Display MyISAM Log File Contents
myisampack — Generate Compressed, Read-Only MyISAM Tables
mysql_plugin — Configure MySQL Server Plugins
mysql_secure_installation — Improve MySQL Installation Security
mysqld_pre_systemd
mysqldumpslow — Summarize Slow Query Log Files
perror — Explain Error Codes
resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
resolveip — Resolve Host name to IP Address or Vice Versa
I think debugging option is also limited in the
mysql-community-server-minimal-5.7.9-1.el7.x86_64.rpm
version.