Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Sebastian Mendel (listssebastianmendel.de)
Date: Fri Apr 18 2008 - 01:25:29 CDT
Pam Astor schrieb:
> I have about a half dozen small databases associated with a
> couple of small shopping carts, discussion forums, etc. All six databases have usernames and
> passwords associated with them, and all the databases are connected to the php
> based forums and shopping carts, no problems with the php applications reading
> and writing data to them.
> I set the databases up a few weeks ago, the first one I set
> up, I canít remember exactly how I set it up.
> Here is what I donít understand. Iím able to login as root, and also the very
> first database I set up, I am able to log in to MySQL via shell using the
> username and password associated with that user. However for all the other databases, I am not
> able to log in to a MySQL shell using the other usernames associated with their
> databases Ė even though the php applications are configured to use the
> usernames, passwords and database names for those users which I can not log in to
> get a shell MySQL session.
> How is it that my php applications can log in to MySQL and I canít get a terminal connection to them? Iím sure itís something about granting a
> login shell but how would I do that?
connectiong from shell means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql