Charles,
2 thing I woul do:
1) Grant permissions to the user that is trying to access mysql on that db.
2) I was having problems accessing mysql using php, although I was
able to access
mysql from the command line. The fix was using the old_password() function
on mysql.
----------------------------------
" To deal with this problem, you can change a password in a special
way. For example,
normally you use SET PASSWORD as follows to change an account password:
SET PASSWORD FOR 'some_user'@'some_host' = PASSWORD('mypass');
To change the password but create a short hash, use the OLD_PASSWORD()
function instead:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');
OLD_PASSWORD() is useful for situations in which you explicitly
want to generate
a short hash. "
---------------------------------
READ THIS:http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
Nestor :-)
On 3/21/06, Charles Gambrell <[EMAIL PROTECTED]> wrote:
> I know this must be a simple issue and maybe I am asking it in the
> wrong place, so if the latter is the case, please direct me to the
> correct place.
>
> I am getting my feet wet with MySQL. I have installed running on
> WhiteBox linux and have created a datebase with one table and put some
> date in it. All seems to work fine form the the command line.
>
> I am now trying to connect throw a browser on a different workstation
> using PHP. I seem to be able to connect ok. I can select the "test"
> database that ships with MySQL but when I try to select the database
> I created the select fails.
>
> I am guessing this is some kind of premissions issue, that I am not
> understanding yet.
>
> I have looked some at the db table i the mysql database and I see this -
>
> host | user | db
> ------------------------------------
> % | | mynewdb
> % | mysql | mynewdb
> % | | test
> % | | test\_%
>
> Where do I need to be looking to see the problem and better yet,
> understanding the problem.
>
> Thanks for the help.
>
> Charles
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
