[PHP] Re: hidden database issue????
bruce wrote: hi... i have a situation with a server that i have. i have mysql installed with php.. the mysql is V4.1.12. i'm trying to see/view a database from the command line and i can't see it when i login to mysql as root. i also can't see it when i try to login to mysql as the given user. How are trying to see it? That is, what command are you using? from the php app, i see that the app makes a valid connection using: host= 192.168.1.foo dbname = cat user= dog passwd = dog i've tracked the code, it's making the connection, and interfacing with the database/tables... however, when i try to access the db as either root/dog, i can't see the database 'cat' mysql -udog -pdog -h192.168.1.foo mysql -uroot -p Have you verified that mysql believes you are root or dog? neither one of these approaches sems to work, ie, i can't see the 'cat' database in the mysql list of tables... any idea what's going on... when i get into mysql as root, i can see/manipulate all the other databases. thanks for any pointers/thoughts/etc... searching google hasn't led to any solid solutions.. thanks -bruce [EMAIL PROTECTED] Perhaps I am just misreading your statement i can't see the 'cat' database in the mysql list of tables..., but you seem to be confusing database and table. If cat is a db, then it is not a table in the mysql db. If you are logged into mysql as a user who has access to cat, you will see it in the output of SHOW DATABASES; You can set cat as the default db by issuing USE cat; After that, you can see the tables in cat by entering SHOW TABLES; If that's not the issue, you can confirm that you are logged in as the correct user with SELECT CURRENT_USER(); and you can check on said user's permissions with (using [EMAIL PROTECTED] as the user): SHOW GRANTS FOR [EMAIL PROTECTED]; If I'm on the wrong track, just send any additional info needed to clarify your problem. Michael -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: MySQL Error 1251 / phpMyAdmin
You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: MySQL Error 1251 / phpMyAdmin
The short answer is, download the php source and add --with-mysql=/your/path/to/mysql to your build options. The long answer is in the directions in the php manual http://us4.php.net/manual/en/install.unix.php. Michael GH wrote: I am still new to the PHP scene could you tell me how I rebuild the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen [EMAIL PROTECTED] wrote: You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
