kuroteikuu

My hostee wishes to just a mysql db and learn how it works but i do not know as of the time how to create a DB for him and him being able to access it without my cPanel Info.

David

Creating it is easy, but they won't have access to it unless you do one of two things:

1) give them your cpanel info, which is not a good idea and recommended against

2) install another version of phpmyadmin, as previously suggested by Haugland on here in another similar question

As for the creation of the database

http://www.ninehours.com/tutorials/4/

You'll have to consult the documentation for phpmyadmin in order to install it. http://www.phpmyadmin.net/home_page/index.php

__________________

H

Yes, setting up an additional copy of phpMyAdmin is a relatively simple process. I kind of lost my database with the details in it when I upgrade MySQL on a school server (oops!), so I can't provide them, but if you need help, let me know.

Otherwise, everything to do with the database can be controlled through queries in PHP. Or you can provide IP access to the database and let them use a GUI.

David

This sounds like something that needs a good easy to understand tutorial written about it. If you have no time to do it in the next few days or so, I have no problem looking into it and trying to write one up.

__________________

H

It doesn't even really merit the need for a tutorial. From what I remember, it was simply a matter of extracting it to a folder, then editing a few lines in a config file (config.default.php).

Those lines would in fact be:

57; value "localhost"

71; value "http"
72; value is the database user you've assigned
73; value is the password to that user

75; value should be name of database you're letting them use

The rest is essentially fairly standard and shouldn't need to be changed.

Z`ohki

You can also only change these 2 :

That will make phpmyadmin show up a login screen, from there on they can login. Like I have on http://websql.fnae.net

mr_fern

You can easily set up a mysql db for a hostee, and their own login info for the db without installing phpmyadmin... the only thing is they won't have access to phpmyadmin, but they'll have access to the database

You log into your CPanel, then you go to "Mysql Databases", or directly via
http://www.{yoursite}.com:2082/frontend/x/sql/index.html

You then create the database with the name they ask for. Cpanel will prefix the name of this database so that the real database name is: {cpanel_username}_{database_name}

Then you go down to add users, and create a login for them. To make things simple, use the same login name and p/w as their ftp. Again, the username will be prefixed to: {cpanel_username}_{their_username}.

Then under the lists of databases, there will be a drop down with the usernames, and a drop down with all the databases. You Select their username, select their database, then click Add User to Database

Now they can access a mysql database.

Example:
you own http://www.kuroteikuu.com and your login is kuroteik
you create a mysql database for your subdomain hostee friend.kuroteikuu.com
he wants a generic database so he can install multiple logical databases in his one database (i.e. creating phpbb and wordpress in the same physical database) so he wants the database named universal

You create a database "universal" (which is really kuroteik_universal) and a login "friend" (which is really kuroteik_friend) with his ftp password

You then add kuroteik_friend to the database kuroteik_universal with all privileges (the All privileges checkbox is checked by default)

Then you're done. If he wants to use this database, in his php scripts he connects with the following information:

server: localhost
username: kuroteik_friend
password: {same as FTP}
database: kuroteik_universal

example code for hostee:

__________________
Nobody doing nothing