Is There A Way To Give Someone Access To Phpmyadm

[rnmcd]

Hi.

 

Is there a way to give someone access to phpmyadmin without giving them full access to cPanel?

 

Thanks.

[rnmcd]

anyone ?

 

 

I'm not always this impatient but I have someone who is willing to help me with a database so I don't want to inconvenience him too much.

Thanks.

[TCH-Thomas]

Unfortunately, I dont think its possible according to this post

[LisaJill]

You can install phpmyadmin yourself (it's pretty easy) and password protect it; then give the id/pass to the people you want to use it. That won't give them access to cpanel if you use a different id/pass.

[rnmcd]

Thank you.

 

I wonder if there is any other way to access phpmyadmin besides cPanel?

[rnmcd]

You can install phpmyadmin yourself (it's pretty easy) and password protect it; then give the id/pass to the people you want to use it. That won't give them access to cpanel if you use a different id/pass.

Thanks Lisa.

 

I posted right after you and didn't notice your reply!

[rnmcd]

So if I install phpmyadmin myself will I need to install a certain version to make it compatible with mySQL (will I also need to install mySQL)?

 

thanks.

[rnmcd]

I am attempting the installation. I am supposed to install the file in my "webservers document root". Is that the "www" folder or the "public_html" folder in my site directory? hmmmm, they look like they're about the same thing.

[borfast]

Yes, they are the same thing. "www" is just a link/shortcut to "public_html".

And yes, that's where you have to install it

[rnmcd]

Of course I'm struggling here.....

 

It's not just that I don't really know what I'm doing it's more that I'm afraid I'm going to screw up something and I'll never be able to figure out how to fix it

 

So far I've installed the myphpadmin on my webservers document root.

 

Now, according to the instructions I need to:

 

Open the file config.inc.php in your favorite editor and change the values for host, user, password and authentication mode to fit your environment. Here, "host" means the MySQL server. Also insert the correct value for $cfg['PmaAbsoluteUri'.

 

Anyone know what the value for MySQL server is?

 

It also wants me to edit the user and password. Do you know if they want an existing password? It doesn't seem like this would be the place that I create a new user and password...or is it?

 

I have no clue to what authentication mode is?

 

 

Yep, I'm lost.

[borfast]

The MySQL server is "locahost".

 

As for the username and password, you can go to the MySQL Manager in cPanel and create a new database there and also a new user (although a new user is not necessary, since you can use your cPanel username and password to access any database in your account).

 

You can set the authentication mode to "config" but beware that anyone will be able to use phpMyAdmin. I'd recommend that you install phpMyAdmin in a directory with a "strange" name and after installing it, go to cPanel and password protect that directory.

[rnmcd]

The following is from the config.inc.php file that I installed:

Your phpMyAdmin url

*

* Complete the variable below with the full url ie

*    http://www.your_web.net/path_to_your_phpMyAdmin_directory/

*

* It must contain characters that are valid for a URL, and the path is

* case sensitive on some Web servers, for example Unix-based servers.

*

* In most cases you can leave this variable empty, as the correct value

* will be detected automatically

How is the correct value automatically detected? If it is 'detected' would it display here:

$cfg['PmaAbsoluteUri']= '';

 

Is the following correct?

$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address

 

 

Raul wrote:

As for the username and password, you can go to the MySQL Manager in cPanel and create a new database there and also a new user (although a new user is not necessary, since you can use your cPanel username and password to access any database in your account).

I am setting up phpmyadmin so that someone else can create databases and tables for me and so that I don't have to give them access to cPanel. Will the username and password that Raul mentioned above be necessary because I don't want them accessing cPanel?

 

Will I need to do a similar-type install for MySQL Manager if the reason I am installing phpmyadmin is so that someone else can create tables and databases?

 

Raul also wrote:

 

You can set the authentication mode to "config" but beware that anyone will be able to use phpMyAdmin. I'd recommend that you install phpMyAdmin in a directory with a "strange" name and after installing it, go to cPanel and password protect that directory.

 

What other authentication modes are there? What does the "config" authentication mode mean?

 

Thank you again.

[TCH-Dick]

I set the following values

>$cfg['PmaAbsoluteUri'] = 'http://www.yousite.com/phpadmin_directory/';
$cfg['Servers'][$i]['host']          = 'localhost';
$cfg['Servers'][$i]['auth_type']     = 'http';
$cfg['Servers'][$i]['user']          = '';
$cfg['Servers'][$i]['password']      = '';

These settings will prompt the user to sign in. You will need to use MySQL Manager to create a database and an user with all priveleges, then add the user to the database. If you don't do this then they will not be able to access phpadmin.

 

The other way to do this is

>$cfg['PmaAbsoluteUri'] = 'http://www.yousite.com/phpadmin_directory/';
$cfg['Servers'][$i]['host']          = 'localhost';
$cfg['Servers'][$i]['auth_type']     = 'config';
$cfg['Servers'][$i]['user']          = 'cpanelusername';
$cfg['Servers'][$i]['password']      = 'password';

Then password protect the directory using Web Protect in cpanel. Then you will not have to create a database before hand.

 

You should not have to install MySQL Manager, you should be able to everything via phpadmin.

On that note make sure you set the following to TRUE or they will not be able to delete databases. If you don't want to give them that option then just leave it set to FALSE.

$cfg['AllowUserDropDatabase'] = FALSE;

[rnmcd]

Thank you Very much Dick and everyone else. I think I got it to work...

 

One question though, when you edited the config.inc.php file which program did you use? I found when I opened it and edited via cPanel (and navigated to the file in the public_html folder and used the "edit file" option) it added line breaks to the file and then myphpadmin wouldn't load (via the URL).

 

I then opened it locally in Notepad but it was less legible (for a novice) because all the lines of text/code ran together. Is there a better way to edit a file like this?

 

 

Thank you.

[TCH-Dick]

I edited it in WordPad, just because it is a easier to read. What do you use to create your site with? You should be able to edit it there also.

[TCH-Dick]

I forgot about this.

Take a look at this thread about Source Code Editors.