centos 7, mysqld not work

[bartik]

Hi my clean install. Mysqld not work.
Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)
not fixing https://docs.directadmin.com/other-hosting-services/mariadb-mysql/troubleshooting.html

Please help me. mysql version 5.7...

Please how to remove it and install mysql 5.6 and change password ?

 

[bartik]

i install mysql 5.6
/usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect
please help me, my server not working!

 

[bartik]

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
please help me...

mysql> SELECT User,Host FROM mysql.user;
+------+--------------------+
| User | Host |
+------+--------------------+
| root | 127.0.0.1 |
| root | ::1 |
| root | localhost |
| root | server1.hostname|
+------+--------------------+
4 rows in set (0,00 sec)

where da_admin user ?

 

[zEitEr]

Hello,

How did you install mysql 5.6? If you tried to install it over the existing MySQL, then it's wrong. You might check existing threads for it:

- https://www.google.com/search?q=site:directadmin.com+reinstall+mysql

 

[bartik]

Hi thank you.
I create user da_admin and problem solved.

 

[EthernetServers]

clean install

it's worth noting that CentOS 7 is EOL (End Of Life) next year, so for future installs, I'd suggest going with something that has more support - like AlmaLinux 8 (security support until 01 Mar 2029).