Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 1 of 2 1 2 LastLast
Results 1 to 10 of 13
  1. #1
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    heres the error I get when I try to run mySQL.

    Code:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2 to server version: 4.0.21-nt
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    mysql> create database newDB;
    ERROR 1044: Access denied for user: '@localhost' to database 'newdb'
    mysql>
    I have setup winmysqladmin.exe - user:root, pass:

    Any ideas? I need some help....

  2.  

  3. #2
    Senior Member mossoi's Avatar
    Join Date
    Apr 2003
    Location
    Englandshire, United Kingdomsville y'all!
    Posts
    1,111
    Member #
    1206
    Liked
    1 times
    I had this a while back on one of my installs. Try using your Windows logon name as the username with a blank password.

  4. #3
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    So in winmysqladmin I must change the username to my windows logon name with no password? Is that where i must specify my username?

    I can browse the database, but I cannot create anything. it gives me that error...

  5. #4
    Senior Member mossoi's Avatar
    Join Date
    Apr 2003
    Location
    Englandshire, United Kingdomsville y'all!
    Posts
    1,111
    Member #
    1206
    Liked
    1 times
    That's what I'm suggesting although it may have been a specific problem to my installation. I couldn't even browse a db even though root looked to have been setup correctly - can you view the users table in the mysql db to see what perms are assigned to root?

  6. #5
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    im not sure. What is the user tables name? can you give me the sql statement that I will need to check the users table plz.

  7. #6
    Senior Member mossoi's Avatar
    Join Date
    Apr 2003
    Location
    Englandshire, United Kingdomsville y'all!
    Posts
    1,111
    Member #
    1206
    Liked
    1 times
    I can browse the database, but I cannot create anything. it gives me that error...
    Which database are you currently browsing?

    The user table is called "user" and is in the database "mySQL" in most installation.

    It depends on where you are running the query from but if you are already browsing the mySQL db then "SELECT * FROM 'user'" should suffice.

  8. #7
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    show databases; - gives me a list of DB's i have, currently only Test. comes with mysql.

    Im running the command line version of mySQL. its called mySQL.exe - which is in the /bin directory.

    Ive tried running that query in the test DB as well as on the shell, before ive selected a DB to use. It doesnt seem to work. complains of an error in my sql statement, or complains that it cannot find user...

  9. #8
    Senior Member rosland's Avatar
    Join Date
    Jul 2003
    Location
    Norway
    Posts
    1,944
    Member #
    2096
    If it's a new install, the only user defined is 'root'.
    if you write:
    Code:
    USE mysql; //to select the mysql DB (contains all config and security data/settings)
    SELECT * FROM user; //displays all registered users from table 'user' in DB 'mysql'and their privileges.
    S. Rosland

  10. #9
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    I tried that and it gave me the same error:
    Code:
    ERROR 1044: Access denied for user: '@localhost' to database 'mysql'


    What now?

  11. #10
    Senior Member jbagley's Avatar
    Join Date
    Sep 2004
    Location
    Cape Town
    Posts
    845
    Member #
    7422
    Im off for the day, But please leave all comments and help. I will get it 2morow moring - i.e 16 hours time - I live in S.A. :classic:


Page 1 of 2 1 2 LastLast

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 03:47 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com