[Error] MySQL [Help]
#1

Help me please.

PHP код:
[ERRORCMySQLConnection::Connect - (error #1045) Access denied for user 'root'@'localhost' (using password: YES) 
This appears in the Mysql.log, I need help, and reinstall everything until the Xampp, but it did not work, I still have this problem.

Sorry my English, i'm from Argentina.
Reply
#2

Check your MySQL connection details on the pawn script. Correct them.
Reply
#3

Quote:
Originally Posted by Lvcnr
Посмотреть сообщение
Check your MySQL connection details on the pawn script. Correct them.
Explicaciуn en Espaсol:

Thx, la Gamemode o .pwn no tiene esos detalles, uso la Gamemode que estб acб pъblica en estй foro, se llama ''Base roleplay edition (LSRP Replica).'' ( https://sampforum.blast.hk/showthread.php?tid=646191 ).

Explication in English:

Thx, the Gamemode or .pwn do not have those details, I use the Gamemode that is open in this forum, it's called Base roleplay edition (LSRP Replica). ( https://sampforum.blast.hk/showthread.php?tid=646191 ).
Reply
#4

Quote:
Originally Posted by Lvcnr
Посмотреть сообщение
Check your MySQL connection details on the pawn script. Correct them.
Estуs son los ъnicos datos que conseguн en la Gamemode de mysql.
PHP код:
public OnGameModeInit()
{
    
AMXProtection();
    
MapAndreas_Init(MAP_ANDREAS_MODE_FULL);
    
import File("mysql.ini"host[16], user[24], database[12], password[32])
    {
        
dbHandle mysql_connect(hostuserdatabasepassword);
        if(
mysql_errno(dbHandle) != 0printf("Non collegato dal database.");
    }
    
mysql_log(LOG_ERROR LOG_WARNING);
    for(new 
a, as = sizeof(AntennasRadio); < as; a++)
         
AntennasRadio[a][arObject] = CreateDynamicObject(3763AntennasRadio[a][arX], AntennasRadio[a][arY], AntennasRadio[a][arZ], AntennasRadio[a][arRX], AntennasRadio[a][arRY], AntennasRadio[a][arRZ]);
    for(new 
lls sizeof(LicensesPoint); lsl++)
         
Pickup_Create(ELEMENT_LICENSEl123923LicensesPoint[l][licenseX], LicensesPoint[l][licenseY], LicensesPoint[l][licenseZ], 00);
    for(new 
ccs sizeof(FarmerZones); csc++)
        
FarmerAreas[c] = CreateDynamicRectangle(FarmerZones[c][0], FarmerZones[c][1], FarmerZones[c][2], FarmerZones[c][3]);
    for(new 
ffs sizeof(FishingZones); fsf++)
        
FishingAreas[f] = CreateDynamicRectangle(FishingZones[f][0], FishingZones[f][1], FishingZones[f][2], FishingZones[f][3]);
    for(new 
jjs sizeof(Jobs); jsj++)
    {
        
Pickup_Create(ELEMENT_JOBj123923Jobs[j][jobX], Jobs[j][jobY], Jobs[j][jobZ], 00);
        
CreateDynamic3DTextLabel(Jobs[j][jobName], COLOR_WHITEJobs[j][jobX], Jobs[j][jobY], Jobs[j][jobZ]+0.430.0INVALID_PLAYER_IDINVALID_VEHICLE_ID100, -1);
    } 
Reply
#5

you're probably using a wrong password for SQL connection.
you can edit them in scriptfiles/mysql.ini
Reply
#6

Quote:
Originally Posted by Mugala
Посмотреть сообщение
you're probably using a wrong password for SQL connection.
you can edit them in scriptfiles/mysql.ini
No, estб correctamente escrita en el archivo que estб en la ruta '' C://Xampp/phpmyadmin/config.inc '' al igual que la ruta que tъ indicas estб bien configurada, cabe resaltar que no es la ъnica GM que me da error en estу de MySQL.
Reply
#7

Quote:
Originally Posted by NailOrduna
Посмотреть сообщение
No, estб correctamente escrita en el archivo que estб en la ruta '' C://Xampp/phpmyadmin/config.inc '' al igual que la ruta que tъ indicas estб bien configurada, cabe resaltar que no es la ъnica GM que me da error en estу de MySQL.
Intenta crear otro usuario en MySQL, no uses root.
Try to create another MySQL user, don't use root.
Reply
#8

Quote:
Originally Posted by NailOrduna
Посмотреть сообщение
Estуs son los ъnicos datos que conseguн en la Gamemode de mysql.
PHP код:
public OnGameModeInit()
{
    
AMXProtection();
    
MapAndreas_Init(MAP_ANDREAS_MODE_FULL);
    
import File("mysql.ini"host[16], user[24], database[12], password[32])
    {
        
dbHandle mysql_connect(hostuserdatabasepassword);
        if(
mysql_errno(dbHandle) != 0printf("Non collegato dal database.");
    }
    
mysql_log(LOG_ERROR LOG_WARNING);
    for(new 
a, as = sizeof(AntennasRadio); < as; a++)
         
AntennasRadio[a][arObject] = CreateDynamicObject(3763AntennasRadio[a][arX], AntennasRadio[a][arY], AntennasRadio[a][arZ], AntennasRadio[a][arRX], AntennasRadio[a][arRY], AntennasRadio[a][arRZ]);
    for(new 
lls sizeof(LicensesPoint); lsl++)
         
Pickup_Create(ELEMENT_LICENSEl123923LicensesPoint[l][licenseX], LicensesPoint[l][licenseY], LicensesPoint[l][licenseZ], 00);
    for(new 
ccs sizeof(FarmerZones); csc++)
        
FarmerAreas[c] = CreateDynamicRectangle(FarmerZones[c][0], FarmerZones[c][1], FarmerZones[c][2], FarmerZones[c][3]);
    for(new 
ffs sizeof(FishingZones); fsf++)
        
FishingAreas[f] = CreateDynamicRectangle(FishingZones[f][0], FishingZones[f][1], FishingZones[f][2], FishingZones[f][3]);
    for(new 
jjs sizeof(Jobs); jsj++)
    {
        
Pickup_Create(ELEMENT_JOBj123923Jobs[j][jobX], Jobs[j][jobY], Jobs[j][jobZ], 00);
        
CreateDynamic3DTextLabel(Jobs[j][jobName], COLOR_WHITEJobs[j][jobX], Jobs[j][jobY], Jobs[j][jobZ]+0.430.0INVALID_PLAYER_IDINVALID_VEHICLE_ID100, -1);
    } 
Find the file mysql.ini and check the credentials used.

According to what you mentioned, if this is the gamemode you downloaded, check this file:
And edit the following:
Код:
#define SQL_HOSTNAME "localhost"
#define SQL_USERNAME "root"
#define SQL_DATABASE "ls-rp"
#define SQL_PASSWORD "root"
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)