RE: mysql database access?

[Mike At S. <spy...@sp...>]

To set a password on a MySQL Database, do:

GRANT ALL PRIVILEGES ON dbname.* TO user@localhost IDENTIFIED BY 'password'

:)

-Mike


> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...]On Behalf Of
> su...@io...
> Sent: Thursday, January 30, 2003 5:16 PM
> To: web...@li...
> Subject: mysql database access?
>
>
> i am not understanding something.
>
> as root in webmin i created a database called "customers".
>
> then using webmin i went into usermin config, usermin module config,
> and mysql database, in the database control list i put the following:
> root: *
> sunruh: customers
>
> and saved.
>
> in my php code i have:
> 	define("DATABASE_HOST", "localhost");
> 	define("DATABASE_USER", "sunruh");
> 	define("DATABASE_PASSWORD", "sunruhpassword");
> 	define("DATABASE_NAME", "customers");
>
> here is the failure i get when trying to connect:
> Warning: Access denied for user: 'sunruh@localhost' (Using
> password: YES) in /u1/sunruh/public_html/modules/include/init on line 26
>
> Unable to connect to "localhost" in order to use the "customers"
> database. Perhaps the database is not running, or perhaps the
> admin needs to change a few variables in
> modules/include/global_settings in order to point to the correct database.
>
> the above code is from global_settings.
>
> so it is obvious that i have something WRONG, but what?
> i don't have a clue.
>
> i didn't set a password on the database.  i don't even know how.
> i'm pretty
> sure i should though.
>
> thoughts, ideas, laughter?
> help please?
>
> thanks,
> steve unruh
>
>
> --
> Earth First...............we'll trail ride the other planets later!
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> -
> Forwarded by the Webmin mailing list at
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>