Pims

Hi all,

I tried to install my own mangos serv. to do it i use http://getmangos.eu/wiki/Compile_MaNGOS_On_Ubuntu

But when i arrived to Create the MaNGOS database whith this command

mysql -u mangos -ppassword < /opt/mangos/mangos/sql/create_mysql.sql

I have an error :

pims@pims-desktop:~$ mysql -u wowserv -pxxxxxxxx < ~/opt/mangos/mangos/sql/create_mysql.sql
ERROR 1045 (28000) at line 1: Access denied for user 'wowserv'@'localhost' (using password: YES)

Have you an idea ?

thnaks

before trying tu create my DB i create user with privilege with :

CREATE USER 'wowserv'@'localhost' IDENTIFIED BY 'xxxxxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'wowserv'@'localhost';
CREATE USER 'wowserv'@'%' IDENTIFIED BY 'xxxxxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'wowserv'@'%';
FLUSH PRIVILEGES;
exit;

ps : scuse for my english

-----------------------------------------------------------------------------------------------------------------------------------

I solve my problème:

When i look for prilège user i see a difference betewn root and wowserv

so you should chnage

GRANT ALL PRIVILEGES ON *.* TO 'wowserv'@'localhost';

by

GRANT ALL PRIVILEGES ON *.* TO 'wowserv'@'localhost' WITH GRANT OPTION;

and use mangos as name for ur user