Hi All, This inquiry concerns 'stock' mysql, php5, apache2, koffice/kexi and phpMyAdmin packages for 10.2 mysql works fine in a shell apache2 and php are serving fine at localhost -> phpMyAdmin and kexi can't establish a connection to mysql at localhost Outside access (intranet/Internet service) is disabled since this is just my development box. If I'm reading the docs correctly, it seems a /config directory and setup.php and maybe a few other files are missing? Any suggestions? TIA & regards, Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
* Carl Hartung
This inquiry concerns 'stock' mysql, php5, apache2, koffice/kexi and phpMyAdmin packages for 10.2
mysql works fine in a shell apache2 and php are serving fine at localhost
-> phpMyAdmin and kexi can't establish a connection to mysql at localhost
Outside access (intranet/Internet service) is disabled since this is just my development box.
If I'm reading the docs correctly, it seems a /config directory and setup.php and maybe a few other files are missing?
on 10.1 but has been same afaict since 9.0. edit /srv/www/htdocs/phpMyAdmin/config.inc.php near line 71 and insert an authentication method (config, http or cookie). I use http: $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)? note: line wrapped if file config.inc.php does not exist in location cited, copy /srv/www/htdocs/phpMyAdmin/libraries/config.default.php as config.inc.php to /srv/www/htdocs/phpMyAdmin/.. one watchout: if you have to copy from the library folder, look for "config.inc.php.rpmnew" and use it instead. if does not help, contact me pat at wahoo.wahoo.no-ip.org and we will discuss :^) gud luk, -- Patrick Shanahan Plainfield, Indiana, USA HOG # US1244711 http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://counter.li.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Thu September 6 2007 09:14, Patrick Shanahan wrote:
on 10.1 but has been same afaict since 9.0.
edit /srv/www/htdocs/phpMyAdmin/config.inc.php near line 71 and insert an authentication method (config, http or cookie). I use http: $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)? note: line wrapped
Thanks for the response, Patrick. And "Hi!" since we haven't corresponded in a while. Hope all is well with you and your's. I'll give this a try and report back accordingly. regards, Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Thu September 6 2007 09:14, Patrick Shanahan wrote:
on 10.1 but has been same afaict since 9.0. <snip>
addendum... Hi Patrick, et al Changing the default 'config' entry to 'http' in line #71 changed *something* because I'm now getting a login prompt. But I started this project so long ago and got interrupted (of course) that I've forgotten if I already set a mysql root password. It won't let me log into either phpMyAdmin or set a password via CLI ;-) I got this: linux:/etc # mysqladmin -u root password ******* mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' So I uncommented 'password = your_password' in /etc/my.cnf and restarted mysql now I'm getting: linux:/etc # mysqladmin -u root password ******* mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' Ideas, please? TIA & regards, Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Thu September 6 2007 19:30, Carl Hartung wrote:
On Thu September 6 2007 09:14, Patrick Shanahan wrote:
on 10.1 but has been same afaict since 9.0.
<snip>
addendum...
Hi Patrick, et al
Changing the default 'config' entry to 'http' in line #71 changed *something* because I'm now getting a login prompt. But I started this project so long ago and got interrupted (of course) that I've forgotten if I already set a mysql root password. It won't let me log into either phpMyAdmin or set a password via CLI ;-) <snip>
I reset my mysqld root password, as follows: in shell 1: # rcmysql stop # killall mysqld # mysqld --skip-grant-tables --user=root in shell 2: mysql mysql> USE mysql mysql> UPDATE user -> SET password=password("new password") [put p/w between quotes] -> WHERE user="root"; mysql> flush privileges; mysql> exit; su (then password) #killall mysqld exit exit All fixed. Thanks everyone! Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (2)
-
Carl Hartung
-
Patrick Shanahan