[CubicVirtuoso]

I dunno if im beating a dead forum post here but I just searched and found this. I have my MySQL database all setup at least how I think it should be setup... I had to create the tables in the command line.

But when I start the server or... when I try to connect with MySQL CC it gives me this error:


[AMXX] SQL error: can't connect: 'Access denied for user 'admin'@'localhost' (using password: YES)'

Now.... i've tried other ips such as my internal ip for this box... 127.0.0.1... my external ip and none of them seem to work. I followed the tutorial above to the T using admin and password as password.

Any help would be great.

[WaZZeR++]

try user root and no password....

[CubicVirtuoso]

L 07/22/2005 - 12:24:22: [MYSQL] DB Connection failed(1045): Access denied for user 'root'@'localhost' (using password: NO)

Any other ideas

[WaZZeR++]

you must config your sql server so it allows connections form user root with ip 127.0.0.1

[CubicVirtuoso]

Woot!!! Thanks man I got connected.

But now I got another problem:


L 07/22/2005 - 13:59:44: [MYSQL] DB Connection failed(1251): Client does not support authentication protocol requested by server; consider upgrading MySQL client
[AMXX] SQL error: can't connect: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'

I just dled mysql yesterday and I'm pretty sure I got the newest client.

Heres what it says under my sql status thingy:

Port: 3306
Server Version 4.1.13-nt via TCP/IP
Version: Client version 5.0.4

[WaZZeR++]

i think you need to give user root ful access to the database...

[CubicVirtuoso]

how do i go about in doing that?

[Siessen]

could any one explain how i can add users with phpmyadmin?

i've got mysql-module connected to mysql-server with adding the user under witch i run the natural selection server on with 'user'@'127.0.0.1'
I also added a database 'amxx' with phpmyadmin and amxx-sql did write admins table in it after a mapchange.
But now i just can't find how to add any admins in the table with it
I'm a noob in these things but i got sofar already and seem so close to add em
also i got some books from the bib like mysql for dummies and so to help me out a bit

but could someone explain it in a simple way please?

[Janet Jackson]

Select your database, click on the SQL icon an paste this under Run SQL query/queries on database amxx:

INSERT INTO admins VALUES ('STEAM_0:1:1234567','password','abcdefghijklu','ce')

and click Go.
Edit to your needs, of course ;)

[Siessen]

thank you, but that's what stated in the first post, and i did do some research before i posted. when i try it this way (connecting as user; connecting to mysql; changed to db amx and finally typed it with my edits offcourse) i get the message [AMXX] No admins found ...

this is also why i want to try it thru phpmyadmin. if anyone could help her e pls