Thanks all for help. I created database and user using "mysql_setpermission"
command. Now i have a user "myuser" with password "mypaswd" for database
"mydb", accessible from any host (selected % as allowable host).
I think the problem is with PHP as phpinfo say's "with no mysql".
Configure Command
'./configure' '--prefix=/usr' '--with-config-file-path=/etc'
'--disable-debug' '--enable-pic' '--enable-shared'
'--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs'
'--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext'
'--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2'
'--with-db3' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes'
'--enable-safe-mode' '--enable-sockets' '--enable-sysvsem'
'--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp'
'--enable-wddx' '--without-mysql' '--without-oracle' '--without-oci8'
'--with-xml'
I am totally New to Linux and install everything from PCQ Linux 7.1 CD
PCQ CD Have following RPM Files
php-devel-4.0.4pl1-9.i386.rpm
php-manual-4.0.4pl1-9.i386.rpm
php-mysql-4.0.4pl1-9.i386.rpm
php-pgsql-4.0.4pl1-9.i386.rpm
How do i add MySQL support to PHP/Apache.
Please Help.
Regards,
Boby
----- Original Message -----
From: Sunil Dhaka <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 4:00 PM
Subject: Re: [LIH] Connecting MySQL
>
> > $cnx = mysql_connect("localhost","root","rootpassword");
> >
> > This fails. After i remove the password it is getting connected. [ie
$cnx
> =
> > mysql_connect("localhost","root"); ] But it fails to select database.
> >
> > $db = mysql_select_db("test",$cnx); /* This Fails */
> >
> > How i create username and password in mysql.
> >
> > I typed mysql in console as root. It go to mysql> prompt without asking
> > anything. When i enter "show databases" command two databases namely
> "mysql"
> > and "test" are listed. I enter "use test" and create a table in test.
> Setup a user for mysql with mysqladmin and grant all rights. Also create
> users with required rights. Having root as a user with a blank password is
> highly insecure. You can also use webmin or phpMyAdmin to administer mysql
> databases
>
>
>
> _______________________________________________
> linux-india-help mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/linux-india-help
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
