MySQL

[Lloyd Logan]

Hi,

why isn't this working, it's saying access denied for user

local user = "root" 
local pass = "" 
local host = "127.0.0.1" 
local db = "accounts" 
server = dbConnect ( "mysql", "dbname=accounts;host=127.0.0.1") 
  
  

Thanks

[50p]

What about username and password?

[Lloyd Logan]

What about username and password?

I tried adding an all privileged account, name = lloyd and pass = mtaserver, but still the same

[50p]

What about username and password?

I tried adding an all privileged account, name = lloyd and pass = mtaserver, but still the same

But you don't seem to be sending it when you call dbConnetc.

[Lloyd Logan]

You're right,

how does this look?

local user = "root" 
local pass = "" 
local host = "127.0.0.1" 
local db = "servermta" 
server = dbConnect ( "mysql", "dbname=servermta;host=127.0.0.1","root") 
  

[50p]

Why don't you try? Looks fine to me. BTW, I don't see any reason why you need to declare new variables if you don't even use them.

[Lloyd Logan]

Why don't you try? Looks fine to me. BTW, I don't see any reason why you need to declare new variables if you don't even use them.

So there isn't a need for the variable 'server'?

[50p]

Why don't you try? Looks fine to me. BTW, I don't see any reason why you need to declare new variables if you don't even use them.

So there isn't a need for the variable 'server'?

You will need the server variable if you want to query the database later on but you don't need other vars if you don't even use them.

[Lloyd Logan]

OK, thanks!