Re: [PHP] Re: Install PHPMyAdmin with urpmi
Dear my friend, Shawn...
Hoorayit works
Thank you very much Shawn
Thank you...Thank you...Thank you...Thank you...1000x
On Tue, 01 Sep 2009 13:14:56 -0500
Shawn McKenzie wrote:
> Ricky Tompu Breaky wrote:
> > Hi, hack.
> >
> > The result is: "Failed".
> >
> > I don't know why my PHP module does not talk to my MySQL.
> >
> > Please keep telling me.
> >
> > On Tue, 1 Sep 2009 12:08:08 +0800
> > hack988 hack988 wrote:
> >
> >> Use follow codes for test your php,php_mysql is work well.
> >> use your ip replace localhost,your mysql port replace 3306 and
> >> username,password to replace mysql_user, mysql_password.
> >> >> error_reporting(2047);
> >> ini_set("display_error","On");
> >> if(mysql_connect('localhost:3306', 'mysql_user',
> >> 'mysql_password')){ echo "Ok";
> >> }else{
> >> echo "Failed";
> >> }
> >> ?>
> >
>
> In php.ini there must be a extension=mysql.so line. If there is, make
> sure that it isn't prefaced by a ; semicolon.
>
> Also, in the script it should be ini_set("display_errors","On");
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Install PHPMyAdmin with urpmi
Ricky Tompu Breaky wrote:
> Hi, hack.
>
> The result is: "Failed".
>
> I don't know why my PHP module does not talk to my MySQL.
>
> Please keep telling me.
>
> On Tue, 1 Sep 2009 12:08:08 +0800
> hack988 hack988 wrote:
>
>> Use follow codes for test your php,php_mysql is work well.
>> use your ip replace localhost,your mysql port replace 3306 and
>> username,password to replace mysql_user, mysql_password.
>> > error_reporting(2047);
>> ini_set("display_error","On");
>> if(mysql_connect('localhost:3306', 'mysql_user', 'mysql_password')){
>> echo "Ok";
>> }else{
>> echo "Failed";
>> }
>> ?>
>
In php.ini there must be a extension=mysql.so line. If there is, make
sure that it isn't prefaced by a ; semicolon.
Also, in the script it should be ini_set("display_errors","On");
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Install PHPMyAdmin with urpmi
Hi, hack.
The result is: "Failed".
I don't know why my PHP module does not talk to my MySQL.
Please keep telling me.
On Tue, 1 Sep 2009 12:08:08 +0800
hack988 hack988 wrote:
> Use follow codes for test your php,php_mysql is work well.
> use your ip replace localhost,your mysql port replace 3306 and
> username,password to replace mysql_user, mysql_password.
> error_reporting(2047);
> ini_set("display_error","On");
> if(mysql_connect('localhost:3306', 'mysql_user', 'mysql_password')){
> echo "Ok";
> }else{
> echo "Failed";
> }
> ?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Install PHPMyAdmin with urpmi
Use follow codes for test your php,php_mysql is work well. use your ip replace localhost,your mysql port replace 3306 and username,password to replace mysql_user, mysql_password. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Install PHPMyAdmin with urpmi
I forgot some important thing.
What Native api are u used by php_mysql?
mysqlnd or mysql client lib?
And What your mysql-server's version?
2009/9/1 hack988 hack988 :
> Config means just use username and password for config file,in that
> case u need't type any things,just open url.
>
> U must set another option in file.
> $cfg['blowfish_secret']='some string';
>
> If not work agian,please check others options.
> $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
> or IP address
> $cfg['Servers'][$i]['port'] = ''; // MySQL port -
> leave blank for default port
> $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect
> to MySQL server ('tcp' or 'socket')
> $cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL
> extension to use ('mysql' or 'mysqli')
>
> 2009/9/1 Ricky Tompu Breaky :
>> Dea my ePal,
>>
>> I tried by editing the line as you adviced just now. But It does not
>> make any difference.
>>
>> After I type root and the password and click the Login Button ('Go'), I
>> am not "in" but just stay on the login form without any error or
>> success message.
>>
>> Is there any another possibility?
>>
>> Please keep telling me.
>> ===
>> On Tue, 1 Sep 2009 04:52:55 +0800
>> hack988 hack988 wrote:
>>
>>> Are u set auth_type to config?
>>> $cfg['Servers'][$i]['auth_type'] = 'config';
>>>
>>> 2009/9/1 Ricky Tompu Breaky :
>>> > Dear Shawn.
>>> >
>>> > Firstly, thank you very much for your quick respond.
>>> >
>>> > I've installed the php-mysql:
>>> > "
>>> > [r...@mandreev linux]# urpmi php-mysql
>>> > Package php-mysql-5.3.0-0.1mud2009.1.i586 is already installed
>>> > [r...@mandreev linux]#
>>> > ".
>>> >
>>> > But I don't know if it's enabled already. How can I know that?
>>> >
>>> > Please keep telling me.
>>> >
>>> > Thank you very much in advance.
>>> > ===
>>> > On Mon, 31 Aug 2009 15:27:30 -0500
>>> > Shawn McKenzie wrote:
>>> >
>>> >> Ricky Tompu Breaky wrote:
>>> >> > Dear my friends,
>>> >> >
>>> >> > I've downloaded and installed PHPMyAdmin. I use Apache2 and
>>> >> > Mandriva 2009.1.
>>> >> >
>>> >> > I have defined in the file of
>>> >> > '/var/www/phpmyadmin/libraries/config.default.php' this things:
>>> >> > "
>>> >> > $cfg['Servers'][$i]['user'] = 'root';
>>> >> > $cfg['Servers'][$i]['password'] = 'mypassword';
>>> >> > ".
>>> >> >
>>> >> > I've done:
>>> >> > "
>>> >> > grant all on *.* to root identified by 'mypassword';
>>> >> > ".
>>> >> >
>>> >> > But I still can not login to MySQL from the PHPMyAdmin with root
>>> >> > account.
>>> >> >
>>> >> > If I try login with MySQL-Query-Browser with 'root' and
>>> >> > 'mypassword', Im logged-in very properly.
>>> >> >
>>> >> > What is my mistake actually?
>>> >> >
>>> >> > Does PHPMyAdmin need to make session on the Apache2? Is it
>>> >> > related to "session" and what I should define in '/etc/php.ini'?
>>> >> >
>>> >> > Please tell me my mistake.
>>> >> >
>>> >> > Thank you very much in advance.
>>> >>
>>> >> Have you installed and enabled the php-mysql extension?
>>> >>
>>> >
>>> >
>>> > --
>>> > PHP General Mailing List (http://www.php.net/)
>>> > To unsubscribe, visit: http://www.php.net/unsub.php
>>> >
>>> >
>>>
>>
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Install PHPMyAdmin with urpmi
Config means just use username and password for config file,in that
case u need't type any things,just open url.
U must set another option in file.
$cfg['blowfish_secret']='some string';
If not work agian,please check others options.
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port -
leave blank for default port
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect
to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL
extension to use ('mysql' or 'mysqli')
2009/9/1 Ricky Tompu Breaky :
> Dea my ePal,
>
> I tried by editing the line as you adviced just now. But It does not
> make any difference.
>
> After I type root and the password and click the Login Button ('Go'), I
> am not "in" but just stay on the login form without any error or
> success message.
>
> Is there any another possibility?
>
> Please keep telling me.
> ===
> On Tue, 1 Sep 2009 04:52:55 +0800
> hack988 hack988 wrote:
>
>> Are u set auth_type to config?
>> $cfg['Servers'][$i]['auth_type'] = 'config';
>>
>> 2009/9/1 Ricky Tompu Breaky :
>> > Dear Shawn.
>> >
>> > Firstly, thank you very much for your quick respond.
>> >
>> > I've installed the php-mysql:
>> > "
>> > [r...@mandreev linux]# urpmi php-mysql
>> > Package php-mysql-5.3.0-0.1mud2009.1.i586 is already installed
>> > [r...@mandreev linux]#
>> > ".
>> >
>> > But I don't know if it's enabled already. How can I know that?
>> >
>> > Please keep telling me.
>> >
>> > Thank you very much in advance.
>> > ===
>> > On Mon, 31 Aug 2009 15:27:30 -0500
>> > Shawn McKenzie wrote:
>> >
>> >> Ricky Tompu Breaky wrote:
>> >> > Dear my friends,
>> >> >
>> >> > I've downloaded and installed PHPMyAdmin. I use Apache2 and
>> >> > Mandriva 2009.1.
>> >> >
>> >> > I have defined in the file of
>> >> > '/var/www/phpmyadmin/libraries/config.default.php' this things:
>> >> > "
>> >> > $cfg['Servers'][$i]['user'] = 'root';
>> >> > $cfg['Servers'][$i]['password'] = 'mypassword';
>> >> > ".
>> >> >
>> >> > I've done:
>> >> > "
>> >> > grant all on *.* to root identified by 'mypassword';
>> >> > ".
>> >> >
>> >> > But I still can not login to MySQL from the PHPMyAdmin with root
>> >> > account.
>> >> >
>> >> > If I try login with MySQL-Query-Browser with 'root' and
>> >> > 'mypassword', Im logged-in very properly.
>> >> >
>> >> > What is my mistake actually?
>> >> >
>> >> > Does PHPMyAdmin need to make session on the Apache2? Is it
>> >> > related to "session" and what I should define in '/etc/php.ini'?
>> >> >
>> >> > Please tell me my mistake.
>> >> >
>> >> > Thank you very much in advance.
>> >>
>> >> Have you installed and enabled the php-mysql extension?
>> >>
>> >
>> >
>> > --
>> > PHP General Mailing List (http://www.php.net/)
>> > To unsubscribe, visit: http://www.php.net/unsub.php
>> >
>> >
>>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Install PHPMyAdmin with urpmi
Dea my ePal,
I tried by editing the line as you adviced just now. But It does not
make any difference.
After I type root and the password and click the Login Button ('Go'), I
am not "in" but just stay on the login form without any error or
success message.
Is there any another possibility?
Please keep telling me.
===
On Tue, 1 Sep 2009 04:52:55 +0800
hack988 hack988 wrote:
> Are u set auth_type to config?
> $cfg['Servers'][$i]['auth_type'] = 'config';
>
> 2009/9/1 Ricky Tompu Breaky :
> > Dear Shawn.
> >
> > Firstly, thank you very much for your quick respond.
> >
> > I've installed the php-mysql:
> > "
> > [r...@mandreev linux]# urpmi php-mysql
> > Package php-mysql-5.3.0-0.1mud2009.1.i586 is already installed
> > [r...@mandreev linux]#
> > ".
> >
> > But I don't know if it's enabled already. How can I know that?
> >
> > Please keep telling me.
> >
> > Thank you very much in advance.
> > ===
> > On Mon, 31 Aug 2009 15:27:30 -0500
> > Shawn McKenzie wrote:
> >
> >> Ricky Tompu Breaky wrote:
> >> > Dear my friends,
> >> >
> >> > I've downloaded and installed PHPMyAdmin. I use Apache2 and
> >> > Mandriva 2009.1.
> >> >
> >> > I have defined in the file of
> >> > '/var/www/phpmyadmin/libraries/config.default.php' this things:
> >> > "
> >> > $cfg['Servers'][$i]['user'] = 'root';
> >> > $cfg['Servers'][$i]['password'] = 'mypassword';
> >> > ".
> >> >
> >> > I've done:
> >> > "
> >> > grant all on *.* to root identified by 'mypassword';
> >> > ".
> >> >
> >> > But I still can not login to MySQL from the PHPMyAdmin with root
> >> > account.
> >> >
> >> > If I try login with MySQL-Query-Browser with 'root' and
> >> > 'mypassword', Im logged-in very properly.
> >> >
> >> > What is my mistake actually?
> >> >
> >> > Does PHPMyAdmin need to make session on the Apache2? Is it
> >> > related to "session" and what I should define in '/etc/php.ini'?
> >> >
> >> > Please tell me my mistake.
> >> >
> >> > Thank you very much in advance.
> >>
> >> Have you installed and enabled the php-mysql extension?
> >>
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Install PHPMyAdmin with urpmi
Are u set auth_type to config? $cfg['Servers'][$i]['auth_type'] = 'config'; 2009/9/1 Ricky Tompu Breaky : > Dear Shawn. > > Firstly, thank you very much for your quick respond. > > I've installed the php-mysql: > " > [r...@mandreev linux]# urpmi php-mysql > Package php-mysql-5.3.0-0.1mud2009.1.i586 is already installed > [r...@mandreev linux]# > ". > > But I don't know if it's enabled already. How can I know that? > > Please keep telling me. > > Thank you very much in advance. > === > On Mon, 31 Aug 2009 15:27:30 -0500 > Shawn McKenzie wrote: > >> Ricky Tompu Breaky wrote: >> > Dear my friends, >> > >> > I've downloaded and installed PHPMyAdmin. I use Apache2 and Mandriva >> > 2009.1. >> > >> > I have defined in the file of >> > '/var/www/phpmyadmin/libraries/config.default.php' this things: >> > " >> > $cfg['Servers'][$i]['user'] = 'root'; >> > $cfg['Servers'][$i]['password'] = 'mypassword'; >> > ". >> > >> > I've done: >> > " >> > grant all on *.* to root identified by 'mypassword'; >> > ". >> > >> > But I still can not login to MySQL from the PHPMyAdmin with root >> > account. >> > >> > If I try login with MySQL-Query-Browser with 'root' and >> > 'mypassword', Im logged-in very properly. >> > >> > What is my mistake actually? >> > >> > Does PHPMyAdmin need to make session on the Apache2? Is it related >> > to "session" and what I should define in '/etc/php.ini'? >> > >> > Please tell me my mistake. >> > >> > Thank you very much in advance. >> >> Have you installed and enabled the php-mysql extension? >> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Install PHPMyAdmin with urpmi
Dear Shawn. Firstly, thank you very much for your quick respond. I've installed the php-mysql: " [r...@mandreev linux]# urpmi php-mysql Package php-mysql-5.3.0-0.1mud2009.1.i586 is already installed [r...@mandreev linux]# ". But I don't know if it's enabled already. How can I know that? Please keep telling me. Thank you very much in advance. === On Mon, 31 Aug 2009 15:27:30 -0500 Shawn McKenzie wrote: > Ricky Tompu Breaky wrote: > > Dear my friends, > > > > I've downloaded and installed PHPMyAdmin. I use Apache2 and Mandriva > > 2009.1. > > > > I have defined in the file of > > '/var/www/phpmyadmin/libraries/config.default.php' this things: > > " > > $cfg['Servers'][$i]['user'] = 'root'; > > $cfg['Servers'][$i]['password'] = 'mypassword'; > > ". > > > > I've done: > > " > > grant all on *.* to root identified by 'mypassword'; > > ". > > > > But I still can not login to MySQL from the PHPMyAdmin with root > > account. > > > > If I try login with MySQL-Query-Browser with 'root' and > > 'mypassword', Im logged-in very properly. > > > > What is my mistake actually? > > > > Does PHPMyAdmin need to make session on the Apache2? Is it related > > to "session" and what I should define in '/etc/php.ini'? > > > > Please tell me my mistake. > > > > Thank you very much in advance. > > Have you installed and enabled the php-mysql extension? > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Install PHPMyAdmin with urpmi
Ricky Tompu Breaky wrote: > Dear my friends, > > I've downloaded and installed PHPMyAdmin. I use Apache2 and Mandriva > 2009.1. > > I have defined in the file of > '/var/www/phpmyadmin/libraries/config.default.php' this things: > " > $cfg['Servers'][$i]['user'] = 'root'; > $cfg['Servers'][$i]['password'] = 'mypassword'; > ". > > I've done: > " > grant all on *.* to root identified by 'mypassword'; > ". > > But I still can not login to MySQL from the PHPMyAdmin with root > account. > > If I try login with MySQL-Query-Browser with 'root' and 'mypassword', > Im logged-in very properly. > > What is my mistake actually? > > Does PHPMyAdmin need to make session on the Apache2? Is it related to > "session" and what I should define in '/etc/php.ini'? > > Please tell me my mistake. > > Thank you very much in advance. Have you installed and enabled the php-mysql extension? -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
