mySQL error

[khansab]

on tryin to run mysql on cmd prompt c:\mysql\bin> mysql error 2003: Can't
connect to mySQL server on 'localhost' (10061) Why i get this error message
and why does winmysqladmin traffic light keeps alternating between red and
green. Ii have installed apache and php, works fine, mySql does not. Anybody
knows how to get this sorted .. Thanks in advance,

[khansab]

on tryin to run mysql on cmd prompt c:\mysql\bin> mysql error 2003: Can't
connect to mySQL server on 'localhost' (10061) Why i get this error message
and why does winmysqladmin traffic light keeps alternating between red and
green. Ii have installed apache and php, works fine, mySql does not. Anybody
knows how to get this sorted .. Thanks in advance,

[David Powers]

khansab wrote:

> on tryin to run mysql on cmd prompt c:\mysql\bin> mysql error 2003: Can't
> connect to mySQL server on 'localhost' (10061) Why i get this error message
> and why does winmysqladmin traffic light keeps alternating between red and
> green. Ii have installed apache and php, works fine, mySql does not.

I don't use winmysqladmin, but Error 2003 means that the MySQL server
has not been started. It looks as though you're using MySQL 3.23 or 4.0.
You can start MySQL at a command prompt like this:

cd c:\mysql\bin
mysqld

You should then be able to communicate with MySQL.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[khansab]

i did this and it worked;

on comd prmopt; mysqld --console

after that, on new cmd screen i'm able to start usin mysql without that horrible error.

but mysqld doesn't start it.

[David Powers]

khansab wrote:

> i did this and it worked;
>
> on comd prmopt; mysqld --console
>
> after that, on new cmd screen i'm able to start usin mysql without that horrible error.
>
> but mysqld doesn't start it.

Glad you have got things working. It sounds as though you are using both
an old version of MySQL and of Windows. When asking for help, it's
always a good idea to mention the versions you're using. So many changes
have taken place with MySQL recently that it's difficult to give a
single set of instructions that will work for both current and older
types of installation.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[khansab]

I have another issue this time with phpmysqladmin. This time i've taken your
advice and below you will see all the versions of the applications i'm using.
Only thing with mysql now is i've to run mysqld --console everytime and then
open cmd prompt in another display to start using mysql. i have installed
following on my windows 2000 pro. apache 2.0.51 (Win32) mysql-4.0.21-win
phpMyAdmin 2.6.0-rc3 php 5.0.1 i have installed phpmyadmin in htdocs in
apache so when i type [url]http://localhost/phpMyAdmin/index.php[/url] . I get this
on the page 'cannot load mysql extension, please check PHP Configuration'
although i'm supposed to see username/password box on entering
[url]http://localhost/phpMyAdmin[/url] , i actually just see the whole directory instead.
in php.ini file, this may help or give you clue; extension=php_mysql.dll
I would really appreciate an answer to make this work, installing and making
mysql work was hard enough . chhers

[David Powers]

khansab wrote:

> when i type [url]http://localhost/phpMyAdmin/index.php[/url] . I get this
> on the page 'cannot load mysql extension, please check PHP Configuration'

What that means is that MySQL has not been enabled in PHP. It was
enabled by default in PHP 4, but not in PHP 5.

Unfortunately, I think you're using the web forum, so your message is
difficult to read in a news reader, and it's not clear whether the
semicolon has been removed from in front of extension=php_mysql.dll. So,
forgive me if some of this is what you have already done.

1. In php.ini, set the value of extension_dir to the location of the
extension files in PHP. Assuming you have installed PHP in c:\php5, this
will be:

extension_dir = "C:\php5\ext\"

2. Remove the semicolon from the beginning of the line that reads:

;extension=php_mysql.dll

Also add another line below to enable mysqli. So the two lines look like
this:

extension=php_mysql.dll
extension=php_mysqli.dll

You don't need mysqli for Dreamweaver, but it's worthwhile enabling at
the same time as mysql.

3. Save php.ini and restart Apache.

4. Create a page with <?php phpinfo(); ?>, load it in a browser, and
check to see whether the configuration shows sections for MySQL and
MySQLi. If they do, everything's fine.

5. If they don't, copy libmysql.dll from the PHP folder to your
windows\system32 folder. Restart Apache again. Everything should now be
fine. The modern method of installing PHP doesn't require this final
step, but I don't know which set of instructions you have been working
from. The recommended method changed in August last year, but a lot of
books and online tutorials still show the old way of doing things.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[khansab]

Thanks for that. It still gave me problem. So, I actually disabled and
uninstalled mysql-4.0.21-win version. downloaded mysql 4.1and then ran setup.
And then 'Cannot create windows service for MySQL. Error: 0' I've checked
windows service and have stopped and started mysql and mysqlwatch. I've
probably messed it up again, now I can't even access or install mysql. I should
never have installed new version Once again, any suggestion for gettin
install through. I hope when it install this version may prove less
problematic. Thanks in advance ..

[David Powers]

khansab wrote:

> Thanks for that. It still gave me problem. So, I actually disabled and
> uninstalled mysql-4.0.21-win version. downloaded mysql 4.1and then ran setup.
> And then 'Cannot create windows service for MySQL.

What that means is that, although you uninstalled MySQL, you didn't
uninstall the Windows MySQL service. Unfortunately, the only way to
uninstall the Windows service is while MySQL 4.0 is still installed. If
you don't want to do that, you could try installing the new Mysql
service with a different name (such as MySQLNew).

If you decide to go the first route (the better option), you must first
uninstall MySQL 4.1. Then reinstall MySQL 4.0. Once you have done that,
open a Windows Command Prompt window, and type:

cd c:\mysql\bin
mysqld --remove

You can then safely install MySQL 4.1.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[khansab]

i tried the first way. removed 4.1.1 I couldn't see 4.0.21 on download page
so downloaded 4.0.24. Installed it and removed it from command prompt. tried
installin 4.1 but got same message as before. oh well, i will try workin with
4.0.24 and see it works with phpmyadmin or if you know any other ideas. Cheers.
Really appreciate all yor feedback.

[Leszek]

Hi
could anyone tell me what is the reason for the error:

Access denied for user 'ODBC@localhost' (using password: NO).

I don't know why I'm getting this error while my connect.php script looks
like this:

<?php
DEFINE ('DB_USER','leszek');
DEFINE ('DB_PASSWORD','password');
DEFINE ('DB_HOST','127.0.0.1');
DEFINE ('DB_NAME_HOTEL',"hotele_uczestnikow");
DEFINE ('DB_NAME_USER',"dane_uczestnikow");
// laczenie z baza danych
$database=mysql_connect(DB_HOST,DB_USER,DB_PASSWOR D) or die("Coldn\'t
contact database server ".mysql_error());
mysql_select_db(DB_NAME_HOTEL)or die("Coldn\'t find database
".mysql_error());
?>

I created account for user: leszek with password required...

Is the ODBC@localhost a default user? What should I do to change it?


i'm using Windows XP SP2 Apache 2.2 php 5 and MySQL 5

Thanks for help.
Leszek

[Bill Karwin]

Leszek wrote:

> Access denied for user 'ODBC@localhost' (using password: NO).

You get this when you have specified no user or password.
It's the default "anonymous" MySQL user when using Windows.

> DEFINE ('DB_USER','leszek');
> DEFINE ('DB_PASSWORD','password');
> $database=mysql_connect(DB_HOST,DB_USER,DB_PASSWOR D) or die("Coldn\'t
> contact database server ".mysql_error());

Apparently, the above is not working. It isn't passing any values for
user and password. I'd recommend in your error output to include the
DB_USER and DB_PASSWORD constants, so you can confirm that they have the
values you think they have.

Regards,
Bill K.

[Jerry Stuckle]

Leszek wrote:

> Hi
> could anyone tell me what is the reason for the error:
>
> Access denied for user 'ODBC@localhost' (using password: NO).
>
> I don't know why I'm getting this error while my connect.php script looks
> like this:
>
> <?php
> DEFINE ('DB_USER','leszek');
> DEFINE ('DB_PASSWORD','password');
> DEFINE ('DB_HOST','127.0.0.1');
> DEFINE ('DB_NAME_HOTEL',"hotele_uczestnikow");
> DEFINE ('DB_NAME_USER',"dane_uczestnikow");
> // laczenie z baza danych
> $database=mysql_connect(DB_HOST,DB_USER,DB_PASSWOR D) or die("Coldn\'t
> contact database server ".mysql_error());
> mysql_select_db(DB_NAME_HOTEL)or die("Coldn\'t find database
> ".mysql_error());
> ?>
>
> I created account for user: leszek with password required...
>
> Is the ODBC@localhost a default user? What should I do to change it?
>
>
> i'm using Windows XP SP2 Apache 2.2 php 5 and MySQL 5
>
> Thanks for help.
> Leszek
>
>

Shouldn't it be define instead of DEFINE?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[email]jstucklex@attglobal.net[/email]
==================