Closed Thread
This thread has been escalated.
Results 1 to 6 of 6

Thread: what's wrong with this mysql command ?

  1. #1
    viao12322 is offline x10Hosting Member viao12322 is an unknown quantity at this point
    Join Date
    Dec 2010
    Posts
    10

    what's wrong with this mysql command ?

    I cannot access phpMyAdmin so I try to run the following command to build my tables thru cron:

    mysql -hlocalhost -u<username> -p<password> <database> < /path/to/sql

    But I get this error:

    ERROR 1045 (28000): Access denied for user '<username>'@'10.33.249.7' (using
    password: YES)

    <username>, <password>, <database> all set properly in mysql

    I wonder if mysql is configured properly, admin, please check.

  2. #2
    masshuu's Avatar
    masshuu is offline Head of the Geese masshuu has a spectacular aura about
    Join Date
    Oct 2007
    Location
    Las Colinas, Tx
    Posts
    2,262

    Re: what's wrong with this mysql command ?

    Is the user added to the database in cpanel?
    All i can offer is to make a simple php script and check if the login details in fact do work.
    Just leading the flock.
    Livewire
    Masshuu ------ carl6969
    descalzo ------------------- Smith6612
    Bryon--------------------------------- Corey
    If you find any post helpful or useful, duck
    \ / This for that post and rep it up.

  3. #3
    viao12322 is offline x10Hosting Member viao12322 is an unknown quantity at this point
    Join Date
    Dec 2010
    Posts
    10

    Re: what's wrong with this mysql command ?

    So, let's recap

    I have one database, one user (viao123_root), who has all privileges to that database, set in cpanel.

    1) phpMyAdmin gave me "Wrong username/password. Access denied."

    2) mysql command gave me "ERROR 1045 (28000): Access denied for user 'viao123_root'@'10.33.249.7' (using
    password: YES)"

    3) my php script gave me "function.mysql-connect</a>]: Access denied for user
    'viao123_root'@'10.33.249.7' (using password: YES)"

    If it is not that the problem of the server, I don't know what it is.

    Please, could some1 please check.

  4. #4
    masshuu's Avatar
    masshuu is offline Head of the Geese masshuu has a spectacular aura about
    Join Date
    Oct 2007
    Location
    Las Colinas, Tx
    Posts
    2,262

    Re: what's wrong with this mysql command ?

    Ok, one last thing i want you to do.
    Can you delete the user and re create it?
    Just leading the flock.
    Livewire
    Masshuu ------ carl6969
    descalzo ------------------- Smith6612
    Bryon--------------------------------- Corey
    If you find any post helpful or useful, duck
    \ / This for that post and rep it up.

  5. #5
    viao12322 is offline x10Hosting Member viao12322 is an unknown quantity at this point
    Join Date
    Dec 2010
    Posts
    10

    Re: what's wrong with this mysql command ?

    I have deleted all database and user and create new ones with different names. (database: viao123_auction, username viao123_admin)

    phpMyadmin still gives the same error.

    php script gives the same error

    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'viao123_admin'@'10.33.248.80' (using password: YES) in /home/viao123/public_html/cron/pennycurl.php on line 4
    Cannot connect to database.

    Thanks

  6. #6
    masshuu's Avatar
    masshuu is offline Head of the Geese masshuu has a spectacular aura about
    Join Date
    Oct 2007
    Location
    Las Colinas, Tx
    Posts
    2,262

    Re: what's wrong with this mysql command ?

    I'm going to escalate this now so an admin can look into it and see if there is an issue.
    Just leading the flock.
    Livewire
    Masshuu ------ carl6969
    descalzo ------------------- Smith6612
    Bryon--------------------------------- Corey
    If you find any post helpful or useful, duck
    \ / This for that post and rep it up.

Closed Thread

Similar Threads

  1. MySQL timezone, NOW() command problems
    By raydarken in forum Programming Help
    Replies: 2
    Last Post: 02-09-2010, 10:46 PM
  2. Wrong MySQL DB count in cPanel
    By misson in forum Free Hosting
    Replies: 1
    Last Post: 11-06-2009, 01:24 PM
  3. MySQL Error! : Wrong Version
    By David in forum Free Hosting
    Replies: 2
    Last Post: 01-04-2008, 03:06 PM
  4. how to connect mysql server from command line
    By selforz in forum Programming Help
    Replies: 0
    Last Post: 12-31-2007, 10:08 PM
  5. Something wrong with MySQL
    By The Corner in forum Free Hosting
    Replies: 1
    Last Post: 11-17-2007, 01:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers