[Phpmyadmin-devel] question (problems logging into phpMyAdmin)
Hello, I'm new to using phpMyAdmin and am having trouble logging in. I'm wondering if someone can help me. I have successfully installed phpMyAdmin on my server (linux, has all the requisite stuff needed to run everything) but i get this error: #1045 - Access denied for user 'root'@'localhost' (using password: YES) (also this one: Cannot load mcrypt extension. Please check your PHP configuration.) i tried the documented suggestion: $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'cbb74bc'; // use here your password $cfg['Servers'][$i]['auth_type'] = 'config' by putting in my own password with root as the login and got same error. also tried $cfg['Servers'][$i]['nopassword'] and generating a script using phpMyAdmin/setup/ which also didn't allow login. i created a "config" folder under phpMyAdmin and dropped the config.inc.php into that, and also dropped it into /setup/frames/ with the various attempts and that didn't work either does anyone know how to fix? thanks!
Hi please users mailing list or help forum for such generic questions, this mailing list is intended for developers discussions. Dne Sat, 6 Feb 2010 23:50:14 -0600 Paul Westmoreland <paulwestmoreland1@gmail.com> napsal(a):
I have successfully installed phpMyAdmin on my server (linux, has all the requisite stuff needed to run everything) but i get this error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
(also this one: Cannot load mcrypt extension. Please check your PHP configuration.)
You need to add mcrypt extension to PHP configuration, dynamic loading is usually disabled in PHP.
i tried the documented suggestion:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'cbb74bc'; // use here your password $cfg['Servers'][$i]['auth_type'] = 'config'
by putting in my own password with root as the login and got same error. also tried $cfg['Servers'][$i]['nopassword'] and generating a script using phpMyAdmin/setup/ which also didn't allow login.
Fist consider rather using cookie authentication which provides better security. Besides that, are you sure you are entering correct password? phpMyAdmin does nothing more than connecting to the MySQL server and passing login information to it.
i created a "config" folder under phpMyAdmin and dropped the config.inc.php into that, and also dropped it into /setup/frames/ with the various attempts and that didn't work either
Please read documentation how to use setup script. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
My apologies. I'm new to all of this, so don't really know the difference between beginner, developer, database query, "generic" or arrogant jerk to be honest. On Sun, Feb 7, 2010 at 3:01 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
please users mailing list or help forum for such generic questions, this mailing list is intended for developers discussions.
Dne Sat, 6 Feb 2010 23:50:14 -0600 Paul Westmoreland <paulwestmoreland1@gmail.com> napsal(a):
I have successfully installed phpMyAdmin on my server (linux, has all the requisite stuff needed to run everything) but i get this error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
(also this one: Cannot load mcrypt extension. Please check your PHP configuration.)
You need to add mcrypt extension to PHP configuration, dynamic loading is usually disabled in PHP.
i tried the documented suggestion:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'cbb74bc'; // use here your password $cfg['Servers'][$i]['auth_type'] = 'config'
by putting in my own password with root as the login and got same error. also tried $cfg['Servers'][$i]['nopassword'] and generating a script using phpMyAdmin/setup/ which also didn't allow login.
Fist consider rather using cookie authentication which provides better security.
Besides that, are you sure you are entering correct password? phpMyAdmin does nothing more than connecting to the MySQL server and passing login information to it.
i created a "config" folder under phpMyAdmin and dropped the config.inc.php into that, and also dropped it into /setup/frames/ with the various attempts and that didn't work either
Please read documentation how to use setup script.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
you're right, and my apoligies, thanks Marc for steering me to the right list. i'll try to address technical questions to the appropriate list in the future On Sun, Feb 7, 2010 at 3:01 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
please users mailing list or help forum for such generic questions, this mailing list is intended for developers discussions.
Dne Sat, 6 Feb 2010 23:50:14 -0600 Paul Westmoreland <paulwestmoreland1@gmail.com> napsal(a):
I have successfully installed phpMyAdmin on my server (linux, has all the requisite stuff needed to run everything) but i get this error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
(also this one: Cannot load mcrypt extension. Please check your PHP configuration.)
You need to add mcrypt extension to PHP configuration, dynamic loading is usually disabled in PHP.
i tried the documented suggestion:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'cbb74bc'; // use here your password $cfg['Servers'][$i]['auth_type'] = 'config'
by putting in my own password with root as the login and got same error. also tried $cfg['Servers'][$i]['nopassword'] and generating a script using phpMyAdmin/setup/ which also didn't allow login.
Fist consider rather using cookie authentication which provides better security.
Besides that, are you sure you are entering correct password? phpMyAdmin does nothing more than connecting to the MySQL server and passing login information to it.
i created a "config" folder under phpMyAdmin and dropped the config.inc.php into that, and also dropped it into /setup/frames/ with the various attempts and that didn't work either
Please read documentation how to use setup script.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Am 07.02.2010 06:50, schrieb Paul Westmoreland:
Hello,
I'm new to using phpMyAdmin and am having trouble logging in. I'm wondering if someone can help me.
I have successfully installed phpMyAdmin on my server (linux, has all the requisite stuff needed to run everything) but i get this error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
(also this one: Cannot load mcrypt extension. Please check your PHP configuration.)
i tried the documented suggestion:
$cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'cbb74bc'; // use here your password
this needs to be the user information for your MySQL server phpMyAdmin uses the above username and password to connect to the MySQL server - so you need to ensure MySQL has a user root with the above password who is allowed to login from localhost
$cfg['Servers'][$i]['auth_type'] = 'config'
using 'cookie' as auth type is more secure, it gives you a login form where you need to enter your MySQL credentials (username and password) phpMyAdmin has no own authentication or privilege system - everything is done against the MySQL server. -- Sebastian Mendel
participants (4)
-
cand. inf. Alexander M. Turek -
Michal Čihař -
Paul Westmoreland -
Sebastian Mendel