phpmyadmin

[mufka]

I'm trying to setup phpmyadmin on my Apache web server. I'm looking for some idiot proof instructions on setting up advanced authentication. The docs just don't do it for me.

Also, opinions on phpmyadmin? is it good/bad?

 

[cmartins]

Hi !!

My Opinion ??? It is the best tool for a MySQL professional.
It is very, very useful !


To use advanced authentication follow these steps...


Edit the file config.inc.php and change the following lines:
------------------------------------------------------------
line 45 - cfgServers[1]['stduser'] = 'your_user'
line 46 - cfgServers[1]['stdpass'] = 'your_password'
line 47 - cfgServers[1]['adv_auth'] = TRUE;



Insert a user on mysql database: (table user)
-----------------------------------------------------
USE mysql;
INSERT INTO user(Host,User,Password,Select_priv)
VALUES("localhost","your_user","your_password","Y"


THAT's ALL


Hope it helps you !
If you get problems .... let me know !

Regards

Claudemir F. Martins

 

[Bastien]

great tool Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[Glowball]

phpMyAdmin is great!

 

[aura9]

check out mascon too. I prefer it over phpMyAdmin although phpMyAdmin is definitely an amazing app. It's not free but I think it blows away phpMyAdmin. It has allowed me to create my MySQL/PHP apps in half the time with it's query saving and report features.

It's definitely worth the $50.

Here's the URL:

http://www.scibit.com

 

[ErikZ]

There's a free version of Mascon on the site, but the site doesn't explain the difference between the FreeMascon and Mascon.