[SOLVED] phpMyAdmin

[bluegroper]

Seems broken.
Installs in wrong directory ?
Needs config.inc.php ?
Others ?
TIA's

[YouCanToo]

Works just fine here. See attached

As installed from synaptic it is installed at /var/www/phpMyAdmin you would access it in the web browser at

http://localhost/phpMyAdmin

Should work just fine as installed from synaptic. You might want to change the password though after installing it.

How did you install phpMyAdmin?  Synaptic?  Tarball? 
What files have you made changes to?

[bluegroper]

Works just fine here. See attached.

As installed from synaptic it is installed at /var/www/phpMyAdmin you would access it in the web browser at

http://localhost/phpMyAdmin

Should work just fine as installed from synaptic. You might want to change the password though after installing it.

How did you install phpMyAdmin?  Synaptic?  Tarball?  
What files have you made changes to?

Yes, installed with Synaptic. On freshly installed and updated PCLOS machine, with mythconverg as sole database.
Seems I was a bit too quick to shout "broken package".
Perhaps a mod could move this thread to "Software" while I try to sort problem between keyboard and chair.

Copied the sample to config.inc.php, and inserted a blowfish secret string.
No other changes.
Connecting from remote computer, I can get this far.

                    

I was just kinda hoping this would work as simply and smoothly as pgAdmin3 works with PostgreSQL.  Alas no.
What username and password should I use to login remotely to phpMyAdmin ?
TIA's for further tips and clues.

[YouCanToo]

Works just fine here. See attached.

As installed from synaptic it is installed at /var/www/phpMyAdmin you would access it in the web browser at

http://localhost/phpMyAdmin

Should work just fine as installed from synaptic. You might want to change the password though after installing it.

How did you install phpMyAdmin?  Synaptic?  Tarball?  
What files have you made changes to?

Yes, installed with Synaptic. On freshly installed and updated PCLOS machine, with mythconverg as sole database.
Seems I was a bit too quick to shout "broken package".
Perhaps a mod could move this thread to "Software" while I try to sort problem between keyboard and chair.

Copied the sample to config.inc.php, and inserted a blowfish secret string.
No other changes.
Connecting from remote computer, I can get this far.

                    

I was just kinda hoping this would work as simply and smoothly as pgAdmin3 works with PostgreSQL.  Alas no.
What username and password should I use to login remotely to phpMyAdmin ?
TIA's for further tips and clues.

By default it is set to

USERNAME: root
PASSWORD: leave it blank

Also make sure MySQL is running

In a terminal window as root enter

service mysqld restart

if it is not running you will see something like this

root@laptop etc]# service mysqld restart
                                                                   [FAILED]
Starting MySQL: .                                         [  OK  ]
[root@laptop etc]#

[bluegroper]

By default it is set to

USERNAME: root
PASSWORD: leave it blank

Also make sure MySQL is running

In a terminal window as root enter

service mysqld restart

if it is not running you will see something like this

root@laptop etc]# service mysqld restart
                                                                   [FAILED]
Starting MySQL: .                                         [  OK  ]

Done all that, but just keeps giving same pushback ?
Error #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES)

I search for any useful logs, but seems there is none.
Please for any more suggestions.
BTW I'm connecting from remote host, not localhost.  Does that make any difference ?
More TIA's


Edit.  Must read this when time permits.
http://www.phpmyadmin.net/documentation/#authentication_modes

[nixer]

As a thought, check the mysql config file to see if it is set to allow for remote connections.  It may be turned off by default for security purposes.  My version of MySQL has the configuration file located at /etc/my.cnf .  Look for a line with "skip-networking".  I think this is the line and it will need to be commented out.  Be sure to restart the mysql service with the command posted above.

This is just an idea, and I am by no means knowledgeable with mysql, but I have seen this problem before.

[YouCanToo]

By default it is set to

USERNAME: root
PASSWORD: leave it blank

Also make sure MySQL is running

In a terminal window as root enter

service mysqld restart

if it is not running you will see something like this

root@laptop etc]# service mysqld restart
                                                                   [FAILED]
Starting MySQL: .                                         [  OK  ]

Done all that, but just keeps giving same pushback ?
Error #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES)

I search for any useful logs, but seems there is none.
Please for any more suggestions.
BTW I'm connecting from remote host, not localhost.  Does that make any difference ?
More TIA's

Edit.  Must read this when time permits.
http://www.phpmyadmin.net/documentation/#authentication_modes

Give this a try in your config.inc.php file change the following

$cfg['Servers'][$i]['controluser'] = 'pmausr';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

to read

$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';   <-- Note they are 2 single quotes without no space

Save the file and than issue the following as the root user in a terminal window

service mysqld restart

Now see if you can get in.  Please let us know the results.

[YouCanToo]

By default it is set to

USERNAME: root
PASSWORD: leave it blank

Also make sure MySQL is running

In a terminal window as root enter

service mysqld restart

if it is not running you will see something like this

root@laptop etc]# service mysqld restart
                                                                   [FAILED]
Starting MySQL: .                                         [  OK  ]

Done all that, but just keeps giving same pushback ?
Error #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES)

I search for any useful logs, but seems there is none.
Please for any more suggestions.
BTW I'm connecting from remote host, not localhost.  Does that make any difference ?
More TIA's


Edit.  Must read this when time permits.
http://www.phpmyadmin.net/documentation/#authentication_modes

You know after reading and rereading the posts it dawned on me. Are you sure that you have a user setup for "pmausr" on the mysql system you are trying to access?  I am just guessing here, that there is no such user on the system named pmausr

I am betting this is your problem. When I set my config.ini.php file to use the pmausr and the password to pmapass that is the exact error I get Error #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES)  Give it a shot and if it works than you will have to create a mysql user and password. What ever you do DO NOT use the default one from the sample configuration.  Also you do not want to run it using the root user either.

Note: you did enter a secret word for this line
$cfg['blowfish_secret'] = 'secret word goes here'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

[bluegroper]

As a thought, check the mysql config file to see if it is set to allow for remote connections.  It may be turned off by default for security purposes.  My version of MySQL has the configuration file located at /etc/my.cnf .  Look for a line with "skip-networking".  I think this is the line and it will need to be commented out.  Be sure to restart the mysql service with the command posted above.

This is just an idea, and I am by no means knowledgeable with mysql, but I have seen this problem before.

Already done that, in order to give remote mythfrontend access to mythbackend (with mysql).
Thx for the tips and ideas.

[bluegroper]

Give this a try in your config.inc.php file change the following

$cfg['Servers'][$i]['controluser'] = 'pmausr';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

to read

$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';   <-- Note they are 2 single quotes without no space

Save the file and than issue the following as the root user in a terminal window

service mysqld restart

Now see if you can get in.  Please let us know the results.

mysql restart NOT needed, its only a php script we're adjusting here.
YES, it now works and so many thx's.   
Just for interest and information, any reason why this package ships in non-working configuration ?
Could or should that be improved ?
How do I give thanks for your helps ?
Just hope that I can help somebuddy else oneday. 
Perhaps with PostgreSQL and pgAdmin3, or maybe mythtv, since I know a little about those.
Much cheers all.
Until next time, ...

[bluegroper]

You know after reading and rereading the posts it dawned on me. Are you sure that you have a user setup for "pmausr" on the mysql system you are trying to access?  I am just guessing here, that there is no such user on the system named pmausr

I am betting this is your problem. When I set my config.ini.php file to use the pmausr and the password to pmapass that is the exact error I get Error #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES)  Give it a shot and if it works than you will have to create a mysql user and password. What ever you do DO NOT use the default one from the sample configuration.  Also you do not want to run it using the root user either.

Note: you did enter a secret word for this line
$cfg['blowfish_secret'] = 'secret word goes here'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

You won that bet !  Who is pmausr ?
Yes, I did setup a blowfish secret.  Seems no login screen without that done.
More thx and cheers
BG

[YouCanToo]

You know after reading and rereading the posts it dawned on me. Are you sure that you have a user setup for "pmausr" on the mysql system you are trying to access?  I am just guessing here, that there is no such user on the system named pmausr

I am betting this is your problem. When I set my config.ini.php file to use the pmausr and the password to pmapass that is the exact error I get Error #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES)  Give it a shot and if it works than you will have to create a mysql user and password. What ever you do DO NOT use the default one from the sample configuration.  Also you do not want to run it using the root user either.

Note: you did enter a secret word for this line
$cfg['blowfish_secret'] = 'secret word goes here'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

You won that bet !  Who is pmausr ?
Yes, I did setup a blowfish secret.  Seems no login screen without that done.
More thx and cheers
BG

Great to hear that you have solved your issue.  

I believe the pmausr is nothing more that an example to be replaced with a user from your system. It would be nice if the author of the program would of put a remark in the file or perhaps in a readme doc, to make it crystal clear that it needed to be changed.  Also you were absolutely correct in not needing the mysql restart. Sometimes old habits about restarting  dies hard.  Anyway it is great that you got it all working. I am sure that someday soon you will be able to help someone else with a problem they are having.