Beginner's Win32 localhost problem
This is a definite newbie question. I downloaded the Win32 version of MySQL to my personal pc (windows 98), in order to become familiar with the software. As directed by the section in the online manual 2.6.2.3 Running MySQL on Windows, I deleted the row in the mysql.user table that holds Host='localhost' and User='' I tried to add a password to the 'root' user, but now I can't access MySql. All I get is the following error message : __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: localhost problem
Hi. On Wed, Nov 21, 2001 at 03:58:46AM +0100, [EMAIL PROTECTED] wrote: i fixed the first problem, i had personal web server installed but i had turned it off now my next problem is this, http://www.pafo.net/mysql2.gif Why didn't you simply quote the error message? It looks arrogant to expect all readers to follow this URL to view something you could have easily typed. Btw, there is even a manual section about this error: http://www.mysql.com/doc/E/r/Error_Access_denied.html how can i get pass this.? [...] Depends on what you want. The error message says that you are trying to connect as ODBC@localhost with the password provided and that this user has no permission to connect. Either the user/password combo is false or the privilege entries on the server are false. Have a look at http://www.mysql.com/doc/A/c/Access_denied.html http://www.mysql.com/doc/U/s/User_Account_Management.html http://www.mysql.com/doc/P/r/Privileges.html for further information. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: localhost problem
On Wed, 21 Nov 2001, Pafo wrote: i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql4.gif i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and i am connected thru a network card in my computer to the internet, all the time. Try logging in with mysql -u root, then read up in the manual on the grant system for adding other users. Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: localhost problem
On Wed, 21 Nov 2001, Pafo wrote: am still getting the same message http://www.pafo.net/mysql5.gif Try without the password. As below, mysql -u root. On Wed, 21 Nov 2001, Pafo wrote: i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql4.gif i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and i am connected thru a network card in my computer to the internet, all the time. Try logging in with mysql -u root, then read up in the manual on the grant system for adding other users. Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: localhost problem
It seems at least one of your username and/or password is not as you might think. You should find the my.ini file, which is either should be in C:\Windows for M$ Windows'98, and change your username-password info. After relaoding mysql, it should function. Regards ? ferhat ? - Original Message - From: Pafo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 4:55 PM Subject: Re: localhost problem am still getting the same message http://www.pafo.net/mysql5.gif regards pafo - Original Message - From: [EMAIL PROTECTED] To: Pafo [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 2:34 PM Subject: Re: localhost problem On Wed, 21 Nov 2001, Pafo wrote: i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql4.gif i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and i am connected thru a network card in my computer to the internet, all the time. Try logging in with mysql -u root, then read up in the manual on the grant system for adding other users. Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
localhost problem
i am having this problem, ( http://www.pafo.net/mysql.gif, a gif file that illustrates the problem ) i am using a firewall and i am connected to the internet all the time. regards pafo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: localhost problem
i fixed the first problem, i had personal web server installed but i had turned it off now my next problem is this, http://www.pafo.net/mysql2.gif how can i get pass this.? regards pafo - Original Message - From: Pafo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 3:43 AM Subject: localhost problem i am having this problem, ( http://www.pafo.net/mysql.gif, a gif file that illustrates the problem ) i am using a firewall and i am connected to the internet all the time. regards pafo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: localhost problem
Hi, - Original Message - From: Pafo [EMAIL PROTECTED] i am having this problem, ( http://www.pafo.net/mysql.gif, a gif file that illustrates the problem ) i am using a firewall and i am connected to the internet all the time. The latter shouldn't be an issue, since according to your screendump you want to run the MySQL server locally and connect to it locally as well? Anyway, the prob is that you are not starting the server properly, and you may also want to adjust your configuration. Just follow http://www.mysql.com/doc/W/i/Windows_installation.html and next pages, for instructions all the way. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'localhost' problem
hello all,
i am running mysql on a red hat linux v7.0 box. when i
am trying to connect to the mysql database to read a
table that is present in the mysql database i am
facing a strange problem. i am able to get into the
database(named 'newone') to read the table (named
'namelist') from the command line on the machine that
is running mysql in any of the following ways:
# mysql -u myname -p mypassword
# mysql -u myname -p mypassword -h localhost
# mysql -u myname -p mypassword -h mydomain.edu
All these 3 commands are successful, without returning
an error.
So i have created a php file named 'namelist.php' to
read this 'namelist' table, which reads like the
following:
html
head
titleName List/title
/head
body
?php
mysql_connect ('localhost','myname','mypassword') or
die ('bUnable to connect to the database/b');
mysql_select_db ('newone') or die ('bUnable to
connect to the database/b');
$result = mysql_query (select * from namelist);
printf (First Name: %sbr\n, mysql_result($result,
0, firstname));
printf (Last Name: %sbr\n, mysql_result($result,
0, lastname));
?
/body
/html
when i run this php script from the browser, it is
producing the following error:
Warning: MySQL Connection Failed: Can't connect to
local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) in
/var/www/html/namelist.php on line 7
Unable to connect to the database
But if change the 'localhost' to 'mydomain.edu' in
line 7 it shows the contents of the table on the
browser without any glitch. My question is eventhough
if it doesn't complain any thing from the command line
when i specify '-h localhost', why it returns the
above error when i run the script in a browser? i am
able to reach the index.html page from the browser by
typing any of the following, on the same machine:
127.0.01
localhost
mydomain.edu
138.xx.xx.xx --my ip address
Can any one please help me with this.
TIA
__
Do You Yahoo!?
Get email alerts NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'localhost' problem
yes..the /etc/hosts file reads like the following:
127.0.0.1 localhost.localdomain localhost
138.xx.xx.xx mydomain.edu mymachine
thanks
--- Lance Rochelle [EMAIL PROTECTED] wrote:
is localhost setup correctly in /etc/hosts file?
i.e. 127.0.0.1 localhost,
if not put that in there and then try again
lance
- Original Message -
From: Crazy Linux [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 2:53 PM
Subject: 'localhost' problem
hello all,
i am running mysql on a red hat linux v7.0 box.
when i
am trying to connect to the mysql database to read
a
table that is present in the mysql database i am
facing a strange problem. i am able to get into
the
database(named 'newone') to read the table (named
'namelist') from the command line on the machine
that
is running mysql in any of the following ways:
# mysql -u myname -p mypassword
# mysql -u myname -p mypassword -h localhost
# mysql -u myname -p mypassword -h mydomain.edu
All these 3 commands are successful, without
returning
an error.
So i have created a php file named 'namelist.php'
to
read this 'namelist' table, which reads like the
following:
html
head
titleName List/title
/head
body
?php
mysql_connect ('localhost','myname','mypassword')
or
die ('bUnable to connect to the database/b');
mysql_select_db ('newone') or die ('bUnable to
connect to the database/b');
$result = mysql_query (select * from namelist);
printf (First Name: %sbr\n,
mysql_result($result,
0, firstname));
printf (Last Name: %sbr\n,
mysql_result($result,
0, lastname));
?
/body
/html
when i run this php script from the browser, it is
producing the following error:
Warning: MySQL Connection Failed: Can't connect to
local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) in
/var/www/html/namelist.php on line 7
Unable to connect to the database
But if change the 'localhost' to 'mydomain.edu' in
line 7 it shows the contents of the table on the
browser without any glitch. My question is
eventhough
if it doesn't complain any thing from the command
line
when i specify '-h localhost', why it returns the
above error when i run the script in a browser? i
am
able to reach the index.html page from the browser
by
typing any of the following, on the same machine:
127.0.01
localhost
mydomain.edu
138.xx.xx.xx --my ip address
Can any one please help me with this.
TIA
__
Do You Yahoo!?
Get email alerts NEW webcam video instant
messaging with Yahoo!
Messenger
http://im.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
archive)
To request this thread, e-mail
[EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
__
Do You Yahoo!?
Get email alerts NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'localhost' problem
I had the same problem with suse 7.2. I see that the path to mysql.sock
is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover
from the mysql that i installed from the distribution. the downloaded
version though stores the mysql.sock in /tmp/mysql.sock - i had to tell
a few of my programs to look for it there. may you need to add a line in
your php program to look for it there
good luck
harry a.
Crazy Linux wrote:
yes..the /etc/hosts file reads like the following:
127.0.0.1 localhost.localdomain localhost
138.xx.xx.xx mydomain.edu mymachine
thanks
--- Lance Rochelle [EMAIL PROTECTED] wrote:
is localhost setup correctly in /etc/hosts file?
i.e. 127.0.0.1 localhost,
if not put that in there and then try again
lance
- Original Message -
From: Crazy Linux [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 2:53 PM
Subject: 'localhost' problem
hello all,
i am running mysql on a red hat linux v7.0 box.
when i
am trying to connect to the mysql database to read
a
table that is present in the mysql database i am
facing a strange problem. i am able to get into
the
database(named 'newone') to read the table (named
'namelist') from the command line on the machine
that
is running mysql in any of the following ways:
# mysql -u myname -p mypassword
# mysql -u myname -p mypassword -h localhost
# mysql -u myname -p mypassword -h mydomain.edu
All these 3 commands are successful, without
returning
an error.
So i have created a php file named 'namelist.php'
to
read this 'namelist' table, which reads like the
following:
html
head
titleName List/title
/head
body
?php
mysql_connect ('localhost','myname','mypassword')
or
die ('bUnable to connect to the database/b');
mysql_select_db ('newone') or die ('bUnable to
connect to the database/b');
$result = mysql_query (select * from namelist);
printf (First Name: %sbr\n,
mysql_result($result,
0, firstname));
printf (Last Name: %sbr\n,
mysql_result($result,
0, lastname));
?
/body
/html
when i run this php script from the browser, it is
producing the following error:
Warning: MySQL Connection Failed: Can't connect to
local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) in
/var/www/html/namelist.php on line 7
Unable to connect to the database
But if change the 'localhost' to 'mydomain.edu' in
line 7 it shows the contents of the table on the
browser without any glitch. My question is
eventhough
if it doesn't complain any thing from the command
line
when i specify '-h localhost', why it returns the
above error when i run the script in a browser? i
am
able to reach the index.html page from the browser
by
typing any of the following, on the same machine:
127.0.01
localhost
mydomain.edu
138.xx.xx.xx --my ip address
Can any one please help me with this.
TIA
__
Do You Yahoo!?
Get email alerts NEW webcam video instant
messaging with Yahoo!
Messenger
http://im.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
archive)
To request this thread, e-mail
[EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
__
Do You Yahoo!?
Get email alerts NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
