On Thursday 16 February 2006 08:11, a tiny voice compelled Thomas T. Veldhouse to write: > Ernie Schroder wrote: > >I am just starting to play with php and mysql. I've got mysql working and > > can log into root accounts using a password. php scripts work on > >http://localhost. For example, http://localhost/php/index.php in a browser > >shows a whole lot of info re php, mysql and apache2. However, I can't seem > > to get phpmyadmin working. > >Going to http://localhost/phpmyadmin, gives me a window asking for > > username and password. If I insert my mysql username (root) and root's > > mysql password, I just get the same box with no error. I've tried adding > > a small > >config.inc.php file to /var/www/localhost/htdocs that is configured like > > so" > > > ><?php > >$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/'; > > Try 'http://127.0.0.1/phpmyadmin/
Tried that too. As well as hostname.domainname/phpmyadmin/ > > >$cfg['Servers'][$i]['host'] = 'MySQL.localhost'; > > '127.0.0.1' > > >$cfg['Servers'][$i]['auth_type'] = 'config'; > > 'cookie' > > >$cfg['Servers'][$i]['user'] = 'root'; > >$cfg['Servers'][$i]['password'] = 'password'; > > don't set the user and password Tried that too. > > >$cfg['blowfish_secret'] = '1234'; > >?> > >I restarted mysql and apache2 and still no joy > >Obviously, I'm missing something, but I can't find anything after many > > hours of searching that points me in the right direction. HELP ;>) > > When prompted for username and password, you probably want to start with > a superuser that you created in MySQL. > > Tom Veldhouse What I hadn't noticed when I emerged phpmyadmin, and none of the documentation I had read had told me, was there is a script installed by phpmyadmin located at: /usr/share/webapps/phpmyadmin/2.7.0_p1/sqlscripts/mysql/2.7.0_p1_create.sql that needs to be run to setup a database for phpmyadmin. I had to delete my previously created tables by doing: # rm -r /var/lib/mysql/* then, after starting mysql, # /usr/bin/mysql_install_db then I could login to mysql, set the root password and run the above script. All is well. I can now run phpmyadmin in the browser at: http://localhost/phpmyadmin/, http://127.0.0.1/phpmyadmin/ or hostname.domainname/phpmyadmin Only thing left to do is learn how to use all this neat stuff. -- Regards, Ernie -- gentoo-user@gentoo.org mailing list
