Error with Mysql on Linux

[Alex_Rubio]

Hello, im trying to put a login panel but when i start the script it says msyql connect failed and all the mysql information is good

http://xrc-clan.com/error.png

[xXMADEXx]

Can you post the script?

[Alex_Rubio]

Sure

  
databaseINFO = { 
host = 'localhost', 
user = 'root', 
pass = 'PRIVATE', 
db = 'mybb', 
} 
  
addEventHandler("onResourceStart",resourceRoot, 
function() 
    local connection = dbConnect('mysql', 'dbname='..databaseINFO.db..';host='..databaseINFO.host, databaseINFO.user, databaseINFO.pass) 
    if connection then 
        databaseINFO.connection = connection 
        outputDebugString('[MYSQL-CONNECT]: Connected') 
    else 
        databaseINFO.connection = false 
        outputDebugString('[MYSQL-CONNECT]: Could not connect') 
    end 
end) 
  
function playerWantToLogin(username,password) 
    local qh = dbQuery(databaseINFO.connection,'SELECT * FROM mybb_users WHERE username = ?',username) 
    local result, row, errmsg = dbPoll ( qh, 5000 ) 
    if row and row > 0 then 
        for id, result in ipairs(result) do 
            local Asalt = result['salt'] 
            local Aname = result['username'] 
            local Apass = result['password'] 
            local convertPass = md5(md5(Asalt):lower()..md5(password):lower()):lower() 
            if convertPass == Apass then 
                return "success",result['uid'] 
            end 
        end 
    end 
end 
  
function getPlayerGroup(accName) 
    local qh = dbQuery(databaseINFO.connection,'SELECT * FROM mybb_users WHERE username = ?',accName) 
    local result, row, errmsg = dbPoll ( qh, 5000 ) 
    if row and row > 0 then 
        for id, result in ipairs(result) do 
            local groupID = result['usergroup'] 
            return groupID 
        end 
    else 
        return false 
    end 
end 
  
function checkUserName(username) 
    local qh = dbQuery(databaseINFO.connection,'SELECT * FROM mybb_users WHERE username = ?',username) 
    local result, row, errmsg = dbPoll ( qh, 5000 ) 
    if row and row > 0 then 
        return "success" 
    end 
    return false 
end 
  
  

In my windows server works. Now, i dont know why it dosent on linux.

[xXMADEXx]

Are you sure you have some type of MySQL server software running? Also, try changing localhost to 127.0.0.1, sometimes that works.

[Alex_Rubio]

OMG Worked!

Thank you very much

[xXMADEXx]

OMG Worked!

Thank you very much

You're welcome, happy to help!