Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::General Support

Archive::General Support Archive area for General Support's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
  #1  
Old 10-03-2004, 02:50 AM
Velox Furor
Fire Beetle
 
Join Date: Oct 2004
Posts: 1
Default error 1045 when setting up

I appogize if this was answered elsewhere, i searched for about half and hour and cound not find anything. Anyway, when setting up the database and doing the whole -

GRANT ALL PRIVILEGES ON * TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

I keep getting an error, yes i did enter in my own username and password, ive tried the entire setup atleast 5 times and i keep getting

ERROR 1045: Access denied for user: '@locahost' (Using password : NO)

So if anyone has any info it would be much appreciated, thanks
  #2  
Old 04-07-2005, 06:06 PM
ReFro
Fire Beetle
 
Join Date: Jul 2004
Posts: 3
Question Same thing

I keep getting the same error and I also tried
mysql -u root mysql
GRANT ALL PRIVILEGES ON *.* TO ****@localhost IDENTIFIED BY '****' WITH GRANT OPTION;
but then I get this
Query OK, 0 Rows affected <0.00 sec>
and it doesn't seem to do anything
  #3  
Old 04-08-2005, 12:35 AM
Belfedia
Demi-God
 
Join Date: Jan 2005
Posts: 1,109
Default

You must replace * or *.* by NAME of your Dbase, i think
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
  #4  
Old 04-08-2005, 06:45 AM
sysadmin
Hill Giant
 
Join Date: Feb 2005
Posts: 163
Default

Quote:
GRANT ALL PRIVILEGES ON <DBname>.<Table> TO <UserName>@<IP> IDENTIFIED BY '<Password>' WITH GRANT OPTION;
Where
-Dbname is an existing DB or any name you used to create a DB.
-UserName can be any user including root.
-IP can be any private, internal or external IP including localhost.
-Password MUST be the password assigned to the user.

Examples:
Quote:
GRANT ALL PRIVILEGES ON eq.* TO velox@192.168.0.101 IDENTIFIED BY 'veloxpass' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON velius.* TO belfedia@localhost IDENTIFIED BY 'belfpass' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO guest@10.0.0.1 IDENTIFIED BY 'nopass' WITH GRANT OPTION;
__________________
Sysadmin.

Last edited by sysadmin; 04-08-2005 at 06:11 PM..
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 05:25 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3