Access denied for user 'aincradfiles'@'localhost' (using password: YES)

[anderson626 0]

Could someone help me with this error in mysql, I have seen it before but of the solutions seen none of them worked,

Could someone tell me how to solve it, I would appreciate it in advance.

 

 

Real Server
Log Offmysql_real_connect: Access denied for user 'aincradfiles'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'aincradfiles'@'localhost' (using password: YES)
   failed, retrying in 5 secondsKern1_Ch1 is not running
PUBLIC_IP: 192.168.1.14 interface em0
HOSTNAME: channel1
mysql_real_connect: Access denied for user 'aincradfiles'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: aincradfiles db: common
cannot start server while no common sql connected
Kern2_Ch1 is not running
 

[Sauug 74]

Hello,

Try to reset passrword with :

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

Did you give the rights with :

GRANT ALL PRIVILEGES ON *.* TO 'aincradfiles'@'localhost' IDENTIFIED BY 'MyNewPass';

And reflush privileges :

FLUSH PRIVILEGES;

[anderson626 0]

6 minutes ago, Sauug said:

Hola,

Intente restablecer la contraseña con :

ALTER USUARIO 'root'@'localhost' IDENTIFICADO POR 'MyNewPass';

¿Le diste los derechos a :

CONCEDER TODOS LOS PRIVILEGIOS EN *.* A 'aincradfiles'@'localhost' IDENTIFICADO POR 'MyNewPass';

Y refluir privilegios :

PRIVILEGIOS DE DESCARGA;

Yes bro, I actually have no idea what else to do.

[Sauug 74]

Can you show me ur my.cnf file ? (/usr/local/etc/mysql/)

[anderson626 0]

2 minutes ago, Sauug said:

Can you show me ur my.cnf file ? (/usr/local/etc/mysql/)

yes bro

 

[client]
port                            = 3306
socket                          = /tmp/mysql.sock

[mysql]
prompt                          = \u@\h [\d]>\_
no_auto_rehash

[mysqld]
user                            = mysql
port                            = 3306
socket                          = /tmp/mysql.sock
bind-address                    = 0.0.0.0
basedir                         = /usr/local
datadir                         = /var/db/mysql
tmpdir                          = /var/db/mysql_tmpdir
slave-load-tmpdir               = /var/db/mysql_tmpdir
secure-file-priv                = /var/db/mysql_secure
log-bin                         = mysql-bin
log-output                      = TABLE
master-info-repository          = TABLE
relay-log-info-repository       = TABLE
relay-log-recovery              = 1
slow-query-log                  = 1
server-id                       = 1
sync_binlog                     = 1
sync_relay_log                  = 1
binlog_cache_size               = 16M
expire_logs_days                = 30
default_password_lifetime       = 0
enforce-gtid-consistency        = 1
gtid-mode                       = ON
safe-user-create                = 1
lower_case_table_names          = 1
explicit-defaults-for-timestamp = 1
myisam-recover-options          = BACKUP,FORCE
open_files_limit                = 32768
table_open_cache                = 16384
table_definition_cache          = 8192
net_retry_count                 = 16384
key_buffer_size                 = 256M
max_allowed_packet              = 64M
query_cache_type                = 0
query_cache_size                = 0
long_query_time                 = 0.5
innodb_buffer_pool_size         = 1G
innodb_data_home_dir            = /var/db/mysql
innodb_log_group_home_dir       = /var/db/mysql
innodb_data_file_path           = ibdata1:128M:autoextend
innodb_temp_data_file_path      = ibtmp1:128M:autoextend
innodb_flush_method             = O_DIRECT
innodb_log_file_size            = 256M
innodb_log_buffer_size          = 16M
innodb_write_io_threads         = 8
innodb_read_io_threads          = 8
innodb_autoinc_lock_mode        = 2
skip-symbolic-links

[mysqldump]
max_allowed_packet              = 256M
quote_names
quick
 

[Sauug 74]

All is good too, no idea too, you can login with ur account with mysql -u aincradfiles -p ?

[anderson626 0]

3 minutes ago, Sauug said:

Todo está bien también, tampoco tengo idea, ¿puedes iniciar sesión con tu cuenta con mysql -u aincradfiles -p?

Yes of course, with the password I gave it

[KolenMG 357]

I had the same issue some days ago. It was when I've paste it a SVF into an existent one on VPS. Also, happened when I've changed the mysql version (mariadb, innodb, etc). Also, it can happen if u use an unsupported version of mysql, for example, for me, mysql56 is the best. I cannot use mysql80 (I believe its a solution, but I suck at these things). 
The solution for me was basically, on freeBSD starting from the begining, meaning that, having a fresh FreeBSD installed, then proceeding to install mysql (fresh) (make sure u are installing a supported version for ur db files) then uploading and extracting the DB and Game as normal. 

[Aigo 93]

You installing it on a fresh VPS?

Open putty and do this. 

Check mysql status. If running then nice.

service mysql status

Open mysql console, this will ask your mysql password.

mysql -u root -p

Now you can check the mysql version.

mysql --version

Make sure to have MySQL5.6 installed if you using the 40k reference files.

I have a mysql5.6 to upload and install, just let me know if needed.

If want to upgrade to mysql8 there are some guides. 

Also, host providers usually use their own firewall. Check the ports from that to verify you can acces from home. Not just the 3306, look for the other ports used at config files to avoid client login issues.

Edited October 11, 2024 by Aigo

[anderson626 0]

3 hours ago, KolenMG said:

Tuve el mismo problema hace unos días. Fue cuando pegué un SVF en uno existente en VPS. También sucedió cuando cambié la versión de MySQL (MariaDB, InnoDB, etc.). También puede suceder si usas una versión no compatible de MySQL, por ejemplo, para mí, MySQL56 es la mejor. No puedo usar MySQL80 (creo que es una solución, pero soy malo en estas cosas). 
La solución para mí fue básicamente, en FreeBSD, comenzar desde el principio, lo que significa que, tener un FreeBSD nuevo instalado, luego proceder a instalar MySQL (nuevo) (asegúrate de que estás instalando una versión compatible para tus archivos de base de datos) y luego cargar y extraer la base de datos y el juego como de costumbre. 

I will need help with that, maybe I haven't found the error yet because I had MYSQL backup and what I did was replace it and that's it, but the same error always appeared, I want to solve it at the root

[KolenMG 357]

Try to add flush privileges for: 'aincradfiles' user. 

 

[anderson626 0]

18 minutes ago, KolenMG said:

Try to add flush privileges for: 'aincradfiles' user. 

 

Nothing, I do it and the user is still denied access

[anderson626 0]

7 hours ago, Aigo said:

You installing it on a fresh VPS?

Open putty and do this. 

Check mysql status. If running then nice.

service mysql status

Open mysql console, this will ask your mysql password.

mysql -u root -p

Now you can check the mysql version.

mysql --version

Make sure to have MySQL5.6 installed if you using the 40k reference files.

I have a mysql5.6 to upload and install, just let me know if needed.

If want to upgrade to mysql8 there are some guides. 

Also, host providers usually use their own firewall. Check the ports from that to verify you can acces from home. Not just the 3306, look for the other ports used at config files to avoid client login issues.

When checking the status with the command

Check mysql status. If running then nice.

service mysql status

 

shows me this error:

mysql does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
 

 

[Kuqsal 203]

Can u check ur CONFIG file please and create in database user give all flush privileges and fix it

[Sauug 74]

10 hours ago, anderson626 said:

When checking the status with the command

Check mysql status. If running then nice.

service mysql status

 

shows me this error:

mysql does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
 

 

Mysql is not enable on rc file, sysrc mysql_enable="YES" 

[CjMt2 28]

mysql -u root -p
SELECT user FROM mysql.user;
SELECT user,host FROM mysql.user;
SELECT * FROM mysql.user;
desc mysql.user;
select user,host from mysql.user;
SELECT current_user();
SELECT user,host, command FROM information_schema.processlist;

First, let's clarify if the user aincradfiles@localhost exists and can authenticate in the Mysql server

If you have the user aincradfiles@localhost then give the command:

mysql -u aincradfiles -p

If it authenticates, then the problem is on the path between bsd and the client you are connecting with.