Upstream MySQL is not directly affected as root user is just not there with the same actions:
... 2014-05-23 13:06:19 2533 [Note] Event Scheduler: Loaded 0 events 2014-05-23 13:06:19 2533 [Note] /home/openxs/dbs/5.6/bin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) [openxs@chief 5.6]$ bin/mysql -uroot test ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [openxs@chief 5.6]$ bin/mysql -uroot -proot test Warning: Using a password on the command line interface can be insecure. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) [openxs@chief 5.6]$ fc -l ... 1046 rm CMakeCache.txt 1047 cmake . -DCMAKE_INSTALL_PREFIX=/home/openxs/dbs/5.6 -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF 1048 make 1049 make install && make clean 1050 cd ~/dbs/5.6 1051 rm -rf data/* 1052 scripts/mysql_install_db --no-defaults --server-id=256 --explicit_defaults_for_timestamp=1 --log-bin --gtid-mode=ON --log-slave-updates=1 --enforce-gtid-consistency=1 --autocommit=0 1053 ls -lh data/ 1054 bin/mysqld_safe --no-defaults --server-id=256 --explicit_defaults_for_timestamp=1 --log-bin --gtid-mode=ON --log-slave-updates=1 --enforce-gtid-consistency=1 --autocommit=0 & 1055 tail data/chief.err 1056 bin/mysql -uroot test 1057 bin/mysql -uroot -proot test
Upstream MySQL is not directly affected as root user is just not there with the same actions:
... dbs/5.6/ bin/mysqld: ready for connections. INSTALL_ PREFIX= /home/openxs/ dbs/5.6 -DCMAKE_ BUILD_TYPE= RelWithDebInfo -DBUILD_ CONFIG= mysql_release -DFEATURE_ SET=community -DWITH_ EMBEDDED_ SERVER= OFF mysql_install_ db --no-defaults --server-id=256 --explicit_ defaults_ for_timestamp= 1 --log-bin --gtid-mode=ON --log-slave- updates= 1 --enforce- gtid-consistenc y=1 --autocommit=0 defaults_ for_timestamp= 1 --log-bin --gtid-mode=ON --log-slave- updates= 1 --enforce- gtid-consistenc y=1 --autocommit=0 &
2014-05-23 13:06:19 2533 [Note] Event Scheduler: Loaded 0 events
2014-05-23 13:06:19 2533 [Note] /home/openxs/
Version: '5.6.17-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
[openxs@chief 5.6]$ bin/mysql -uroot test
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[openxs@chief 5.6]$ bin/mysql -uroot -proot test
Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[openxs@chief 5.6]$ fc -l
...
1046 rm CMakeCache.txt
1047 cmake . -DCMAKE_
1048 make
1049 make install && make clean
1050 cd ~/dbs/5.6
1051 rm -rf data/*
1052 scripts/
1053 ls -lh data/
1054 bin/mysqld_safe --no-defaults --server-id=256 --explicit_
1055 tail data/chief.err
1056 bin/mysql -uroot test
1057 bin/mysql -uroot -proot test