hi
i am trying to set up LAMP on an old pc i have installed linux, apache, mySQL and PHP following this guide Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 11.3 (LAMP) | HowtoForge - Linux Howtos and Tutorials.
i have installed phpMyAdmin but when i try and acess it i get this error
Error
MySQL said:Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
im using a config.inc.php as the config file
<?php
$i=0;
$i++;$cfg’Servers’]$i]‘user’] = ‘user name’;
$cfg’Servers’]$i]‘password’] = ‘password’;
$cfg’Servers’]$i]‘auth_type’] = ‘config’;?>
im using webmin to remotly administer the server on the sql server module i get this warning
Warning: The Perl module DBD::mysql is not installed on your system, so Webmin will not be able to reliably access your MySQL database. Click here to install it now.
put when i try and install the module it does not install i get this output
Executing /usr/bin/perl Makefile.PL && make …
PLEASE NOTE:
For ‘make test’ to run properly, you must ensure that the
database user ‘’ can connect to your MySQL server
and has the proper privileges that these tests require such
as ‘drop table’, ‘create table’, ‘drop procedure’, ‘create procedure’
as well as others.mysql> grant all privileges on test.* to ‘’@‘localhost’ identified by ‘s3kr1t’;
You can also optionally set the user to run ‘make test’ with:
perl Makefile.PL --testuser=username
I will use the following settings for compiling and testing:
cflags (mysql_config) = -I/usr/include/mysql -fomit-frame-pointer -fmessage-length=0 -D_FO
RTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -DPIC -fPIC -DUNDEF
_HAVE_INITGROUPS -fno-strict-aliasing -DUNIV_LINUX -DUNIV_LINUX
embedded (mysql_config) =
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib -L/
usr/lib64 -lssl -lcrypto
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 1
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (guessed ) =To change these settings, see ‘perl Makefile.PL --help’ and
‘perldoc INSTALL’.Checking if your kit is complete…
Looks good
Using DBI 1.609 (for perl 5.012001 on i586-linux-thread-multi) installed in /usr/lib/perl5/vendor_pe
rl/5.12.1/i586-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::mysql
sh: make: command not found
i can log into mySQL via a ssh connecting using my root user name and password
i really dont know whats going on and really could do with some help
thanks
willem