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