Setting up New mySQL User

how do they access db

[dauction]

I have cpanel and PHpAdmin to admin the MYSQl db and I can add a new user just fine and I see all the connnection strings etc..

I am lost though as to how to allow this user access to the database(without allowing cpanel acess...just access to the DB)...I setup a user name and password via Phpadmin (and permissions what they can and cannot do)but what program or path do they use to gain access..where is their "login" access point

I should already know something as simple as this this but I dont appreciate some help

[rocknbil]

mySQL connects remotely; that is, similar to the way you request a web page via the browser, you would connect to the database via IP address or server name from any location, supplying the database name, user name and password in the connection.

You don't access directories or files. mySQL is a server listening for requests, just like a web server. So it is listening for connections from valid users registered in it's database.

Usually this is done via a scripting language, using the mySQL drivers installed on the operating system issuing the request. Search your programming language's documentation for mySQL, and it will provide samples. Perl example:

use DBI; # perl database access module
$login = 'database_user_name';
$pass = 'this_user_pass';
$host = 'your.mysql.server.com';
$name = 'database_name';
$conn = "DBI:mysql:$name:$host";
$dbh = DBI->connect("$conn",$login,$pass);

The variable $dbh is now an object representing the database and queries are applied to it.

PHP, ASP, and other languages all have different but similar methods of accessing the database.

[dauction]

Thanks Rocknil.. So access is through
http://example.com:2082/3rdparty/phpMyAdmin/
and a typcal login does appear BUT it wants to access through cpanel ! And clearly am not going to assign a cpanel access

I do have the connection strings ...but unsure of where to use them ..in a FTP program ? Tried that with no success
I will go read MYSql documentation some more ..just over my head

BTW.. This is a GREAT example for those wondering whther it makes any sense to learn database installations , php , html etc..

I've always been a advocate for gui programs to simplify as I have far to many other things to worry about than learning languages etc..

This is the downside of that though.. This is actually very easy what I need to do and I am completely stuck because I am 99% GUI ..not that it is totally necesassy I can simply pay someone a few bucks to handle it..it's just that I SHOULD be able to do this type of stuff.

[edited by: tedster at 8:09 pm (utc) on Sep. 2, 2008]
[edit reason] switch to example.com [/edit]

[Anyango]

Simple !

You Just install another phpMyAdmin on your own site which connects to the same mySQL server and give those users the url to it, when they login with their own password they will be able to manage the database (which they have access to), unless i misunderstood something. ;)

Edit: So that way they will login to phpMyAdmin on your site and you will still be able to login to it via your Cpanel without them knowing the Cpanel login.
So their login url will be like
http://example.com/phpMyAdmin/

[edited by: Anyango at 6:56 pm (utc) on Sep. 2, 2008]

[edited by: tedster at 8:09 pm (utc) on Sep. 2, 2008]
[edit reason] swtich to example.com - it can never be owned [/edit]

[Anyango]

Didn't do any help ?