can’t select database

  • Resolved ronchicago

    (@ronchicago)


    19 years, 5 months ago

    the can’t select database says my username and password is correct. i can see the database name in cpanel and did a mysql query on all databases on my server = the db name is a match. the database name matches in phpMyadmin which also says no tables found on database. my isp is aware of this problem and said all systems go on isp. my settings in config.php match – i have tried with and without the prefix.

    any thoughts? is there another work around?

Viewing 6 replies - 1 through 6 (of 6 total)
  • Doodlebee

    (@doodlebee)

    19 years, 5 months ago

    you have a link? And who is your host?

    Thread Starter ronchicago

    (@ronchicago)

    19 years, 5 months ago

    http://www.petmonologues.org/petorg022207/wp-login.php

    host = http://rackforce.com ( i am on plan = dds200-L )

    another blog is running swell…

    Doodlebee

    (@doodlebee)

    19 years, 5 months ago

    Usually, when I see this error, it’s because I put a space in somewhere I shouldn’t have, or I got a couple of letters mixed up.

    Are you sure you didn’t do that? Or maybe the database name is supposed to be “petorg_dbtest”?

    drmike

    (@drmike)

    19 years, 5 months ago

    Either that or you’re the 1% where you have to put in the actual database server name instead of using localhost.

    Thread Starter ronchicago

    (@ronchicago)

    19 years, 5 months ago

    i triple checked. i keystroked and copy/paste. i copy/paste and sent to my isp. i just sent them something regarding my phpMyadmin client. i thought i would open up a new database but it does not give me the option and it says in red, no priviledges. this is my first venture in phpmyadmin so i asked to see if it was normal. next i tried the msql connect () function and got a #1064 syntax error. here is my query: $dbc = mysql_connect ($host, $user, $password);

    so close ;-(

    Thread Starter ronchicago

    (@ronchicago)

    19 years, 5 months ago

    ok – I AM IN! My host did the following…

    mysql> grant all on database name.* to username@localhost identified by ‘password’;
    Query OK, 0 rows affected (0.01 sec)

    This kind of stuff is both maddening and rewarding – I guess ! ;-O

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘can’t select database’ is closed to new replies.

Tags