Alexander1974
Verified User
MySQL will not start anymore after an upgrade on centos 6 to MySQL 8.0 I want to uninstall and then reinstall all builds but have been busy all night and keep having problems installing and restarting MySQL. Is it possible to throw everything except DirectAdmin from the server so that the whole build can be redone without the existing problems? I am unable to remove MySQL now.
Current errors:
We seem to have an erro when trying to SET PASSWORD FOR 'root'@'localhost' = PASSWORD('DELETED')
*********************************
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error with the default password. Trying root cleanup via the /root/.mysql_secret
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Hmm.. issue setting the root password. There might be issues later trying to setup the DA account
Setting DirectAdmin user and password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Securing installation...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
warning: erase unlink of /etc/init.d/mysql failed: No such file or directory
*****************************************************
*****************************************************
It seems as though mysql has already been installed.
The directory /var/lib/mysql has been found. For the best results, its recommended that this be deleted.
All database data will be lost if you delete it
Do you want to delete it? (y is recommended)? (y,n) : y
mv: cannot move `/var/lib/mysql' to `/var/lib/mysql.backup/mysql': Directory not empty
Installing MySQL
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
Data needs to be created in /var/lib/mysql/mysql ...
chown: invalid user: `da_admin'
Cannot change ownership of the database directories to the 'da_admin'
user. Check that you have the necessary permissions and try again.
usermod: no changes
Starting MySQL. ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
Waiting for mysqld to start....
Setting MySQL Root Password...
Found /root/.mysql_secret
Error setting root pass with /usr/bin/mysqladmin. Trying SET PASSWORD via /root/.mysql_secret
/usr/bin/mysql: unknown option '--connect-expired-password'
*********************************
We seem to have an erro when trying to SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Deleted')
*********************************
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error with the default password. Trying root cleanup via the /root/.mysql_secret
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Hmm.. issue setting the root password. There might be issues later trying to setup the DA account
Setting DirectAdmin user and password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Securing installation...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@server scripts]#
[root@server scripts]# systemctl stop mysqld
bash: systemctl: command not found
[root@server scripts]# ^C
[root@server scripts]#
Current errors:
We seem to have an erro when trying to SET PASSWORD FOR 'root'@'localhost' = PASSWORD('DELETED')
*********************************
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error with the default password. Trying root cleanup via the /root/.mysql_secret
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Hmm.. issue setting the root password. There might be issues later trying to setup the DA account
Setting DirectAdmin user and password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Securing installation...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
warning: erase unlink of /etc/init.d/mysql failed: No such file or directory
*****************************************************
*****************************************************
It seems as though mysql has already been installed.
The directory /var/lib/mysql has been found. For the best results, its recommended that this be deleted.
All database data will be lost if you delete it
Do you want to delete it? (y is recommended)? (y,n) : y
mv: cannot move `/var/lib/mysql' to `/var/lib/mysql.backup/mysql': Directory not empty
Installing MySQL
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [100%]
Data needs to be created in /var/lib/mysql/mysql ...
chown: invalid user: `da_admin'
Cannot change ownership of the database directories to the 'da_admin'
user. Check that you have the necessary permissions and try again.
usermod: no changes
Starting MySQL. ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
Waiting for mysqld to start....
Setting MySQL Root Password...
Found /root/.mysql_secret
Error setting root pass with /usr/bin/mysqladmin. Trying SET PASSWORD via /root/.mysql_secret
/usr/bin/mysql: unknown option '--connect-expired-password'
*********************************
We seem to have an erro when trying to SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Deleted')
*********************************
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error with the default password. Trying root cleanup via the /root/.mysql_secret
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Hmm.. issue setting the root password. There might be issues later trying to setup the DA account
Setting DirectAdmin user and password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Securing installation...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@server scripts]#
[root@server scripts]# systemctl stop mysqld
bash: systemctl: command not found
[root@server scripts]# ^C
[root@server scripts]#