Sara Woglom wrote:
Thanks Shawn!!
You should be thanking Mladen Adamovic for pointing you to:
http://dev.mysql.com/doc/mysql/en/grant.html
This page holds your answer. From the error message you got
Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to
this MySQL
I have just installed MySQL 5.0, and I am unable to connect to it from my
own (remote) machine. It all works fine when I open mysqladmin from the
server itself, so I know the installation is OK. I am working on a small
LAN of about 15 PCs. When I try to telnet to the default port (3306), I get
Sara Woglom wrote:
I have just installed MySQL 5.0, and I am unable to connect to it from my
own (remote) machine. It all works fine when I open mysqladmin from the
server itself, so I know the installation is OK. I am working on a small
LAN of about 15 PCs. When I try to telnet to the
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 10, 2006 1:08 PM
To: Sara Woglom
Cc: mysql@lists.mysql.com
Subject: Re: Cannot connect to server
Sara Woglom [EMAIL PROTECTED] wrote on 03/10/2006 11:54:03 AM:
I have just installed MySQL 5.0, and I am unable to connect to it from
my
own
Okay, with the good help I was getting, and looking at the all clues MySQL
was giving me, like Table 'mysql.host' doesn't exist and Can't find file:
'./mysql/host.frm', I concluded that the 4.1.9 installation conflicts with
the default 4.0.18 installation. For instance, 4.0.18 expects files in
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start
up.
In the console I get these messages:
The database cluster will be initialized with locale C.
creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok
creating directory
Alex Majora wrote:
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't
start up.
In the console I get these messages:
The database cluster will be initialized with locale C.
creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok
creating directory
Michael Stassen wrote:
That doesn't appear to be mysql.
Now that I look closely, that must be a database for RMDB. Sorry I got the
two confused.
Are you sure mysqld is running? You got a shutdown message right before
this.
Apparently, it's not running, as there is no mysqld process running in
The postmaster is a Postgres daemon, and pg_shadow is the user table for
postgres.
Clint
From: Michael Stassen [EMAIL PROTECTED]
To: Alex Majora [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: mysql.sock file exists, but still cannot connect to server
Date: Wed, 19 Jan 2005 17:42:34
Additionally, this is what I get when I try to launch mysqld manually:
$ sudo ./bin/mysqld_safe
[1] 2058
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file
/usr/local/mysql/data/whitestar.alpha.net.pid
050119 17:13:12 mysqld ended
Is there a way
Alex Majora wrote:
Michael Stassen wrote:
That doesn't appear to be mysql.
Now that I look closely, that must be a database for RMDB. Sorry I got
the two confused.
Are you sure mysqld is running? You got a shutdown message right
before this.
Apparently, it's not running, as there is no mysqld
Details should be in the .err file in the data directory
(/usr/local/mysql/data/whitestar.alpha.net.err, in your case).
Michael
Alex Majora wrote:
Additionally, this is what I get when I try to launch mysqld manually:
$ sudo ./bin/mysqld_safe
[1] 2058
Starting mysqld daemon with databases from
On Wednesday, January 19, 2005 9:14 PM Michael Stassen wrote:
Details should be in the .err file in the data directory
Here's the contents of the file:
050119 17:30:02 mysqld started
050119 17:30:02 [Warning] Setting lower_case_table_names=2 because file
system
for
On Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote:
tcp0 0 *:3307 *:*
LISTEN
It seems that the correct socket is used. Here is the output:
unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
unix 2 [ ACC ]
n Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote:
tcp0 0 *:3307 *:*
LISTEN
It seems that the correct socket is used. Here is the output:
unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
unix 2 [ ACC ] STREAM
Sami Maisniemi [EMAIL PROTECTED] writes:
It seems that the correct socket is used. Here is the output:
unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
unix 2 [ ACC ] STREAM LISTENING 3307 public/showq
...
I tried to connect to socket #3307 as
I finally managed to install MySQL succesfully. I created a simple DB with two
different tables. I also created a simple PHP script to list all DBs and
tables.
However, it seems that the PHP script cannot access MySQL server, because the
following error message is displayed:
Warning:
mydatabase
rick
People will forget what you said. People will forget what you did.
But people will never forget how you made them feel.
- Original Message -
From: Sami Maisniemi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 22, 2004 12:25 PM
Subject: PHP script cannot connect MySQL
I finally managed to install MySQL succesfully. I created a simple DB with
two
different tables. I also created a simple PHP script to list all DBs and
tables.
However, it seems that the PHP script cannot access MySQL server, because
the
following error message is displayed:
_
This
I finally managed to install MySQL succesfully. I created a simple DB with
two
different tables. I also created a simple PHP script to list all DBs and
tables.
However, it seems that the PHP script cannot access MySQL server, because the
following error message is displayed:
Warning:
On Monday 22 March 2004 20:36, [EMAIL PROTECTED] wrote:
This means that your server is not up, most likely. Can you connect from
the command line? try running
ps -efc | grep mys
do you see an entry for mysqld?
It seems that the server is up and running, because I am able to see
On Monday 22 March 2004 21:45, [EMAIL PROTECTED] wrote:
This error could result from a number of possible problems. First off I
would check to make sure the mysqld is running and attaching to the default
socket (3306). If you have it set up otherwise, you will likely need the
connect to
Did you provide access to the databases as root? Is there a password
associated with access? For instance, how do you statr mysql from the
command line: mysql -u root -ppassword mydatabase
I think I am using root access, but should I create another user name for
MySQL? On the command line,
At 22:00 22-03-2004 +0200, Sami Maisniemi wrote:
Did you provide access to the databases as root? Is there a password
associated with access? For instance, how do you statr mysql from the
command line: mysql -u root -ppassword mydatabase
I think I am using root access, but should I create
It seems that mysqld is up and running (view the results below), but could
you
specify how to check the socket, please?
Based on your ps information, the socket will likely be in the
/usr/local/mysql/data/my.cnf file under the [mysqld] area. Another way
to tell if there is a socket open for the
Sami Maisniemi writes:
I think I am using root access, but should I create another user name for
MySQL? On the command line, I start MySQL by typing just 'MySQL'. How can I
view the user?
from the mysql program:
mysql use mysql
mysql select User,Host,Password,Select_priv from user;
which will
On Monday 22 March 2004 22:43, [EMAIL PROTECTED] wrote:
specify how to check the socket, please?
Based on your ps information, the socket will likely be in the
/usr/local/mysql/data/my.cnf file under the [mysqld] area. Another way
to tell if there is a socket open for the server would be to
tcp0 0 *:3307 *:* LISTEN
It seems that the correct socket is used. Here is the output:
unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
unix 2 [ ACC ] STREAM LISTENING 3307 public/showq
Looks like
Sami Maisniemi [EMAIL PROTECTED] writes:
mysql use mysql
mysql select User,Host,Password,Select_priv from user;
which will show basic access capabilities for user/host/password
Hmmm ... did not work as you can see:
mysql select User,Host,Password,Select_priv from user;
ERROR 1054: Unknown
Hi All,
Having problems with connecting to mysql server as we have had to change all
the IP addresses on the server. I am assuming that localhost is the problem,
how can I manually change localhost to be an IP address?
The error message is:
Warning: mysql_connect(): Can't connect to local MySQL
On Mon, 1 Sep 2003 11:34:31 +0100
Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote:
The error message is:
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/tmp/mysql.sock' (111) in /home/sites/.. on line 3
Unable to select database
is MySQL socket really placed
Could not read response from last sender :o(
-Original Message-
From: Phil Ewington - 43 Plc [mailto:[EMAIL PROTECTED]
Sent: 01 September 2003 11:35
To: Mysql
Subject: Cannot Connect to Server
Hi All,
Having problems with connecting to mysql server as we have had to change all
the IP
On Mon, 1 Sep 2003 11:51:07 +0100
Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote:
Could not read response from last sender :o(
from [EMAIL PROTECTED] ?
it's Yet Another Spammer(or Autoresponder) on this list. YAS(A) =)
dunno why list administration haven't blocked him yet.
These robots are
Make sure
%WINDOWS%\my.ini has the entry
bind-address=127.0.0.1
-Martin
- Original Message -
From: Antony Dovgal [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 3:42 AM
Subject: Re: Cannot Connect to Server
On Mon, 1 Sep 2003 11:34:31 +0100
We're having severe problems here. We've been running 2.23.3 on Redhat 6.2
for a while and all has been well. I've also installed mysql several times
with no issues. We had a hard drive go out today, and since then we have not
been able to get mysql to successfully start and accept connections.
35 matches
Mail list logo