f



Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD

I got this error starting mysql from installation:
sh-3.2# /usr/local/mysql/bin/mysql -user=mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock' (2)
The same goes for starting as root.

I do the
sh-3.2# find ~ -name mysql.sock on my home directory,
find . -name mysql.sock in the /usr/local directory and,
find / -name mysql.sock and don't get a response.

I haven't gotten the mysqld started once from the installation.
I removed the other installations.

MY.CONF:
[client]
socket=/var/mysql/mysql.sock

PHP.INI
; Default socket name for local MySQL connects.  If empty, uses the
built-in
; MySQL defaults.
mysql.default_socket =  /var/mysql/mysql.sock


The entire MY.CONF
[mysqld]
#Path to installation directory. All paths are usually resolved
relative to this.
basedir=/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/
#Path to the database root
datadir=/usr/local/mysql-5.1.40-osx10.5-powerpc/data
#Path to the temporary directory.
tmpdir=/private/tmp
#The size of the buffer used for index blocks. Increase this to get
better index handling (for all reads and multiple writes) to as much
as you can afford; 64M on a 256M machine that mainly runs MySQL is
quite common.
key_buffer_size=8192k
#Each thread that needs to do a sort allocates a buffer of this size.
sort_buffer_size=2M
#If no specific storage engine/table type is defined in an SQL-Create
statement the default type will be used.
default-storage-engine=myisam
[client]
socket=/var/mysql/mysql.sock

Why does it think there are two mysql.sock?
thanks,
0
jlrough (485)
12/29/2009 12:22:21 AM
comp.databases.mysql 6944 articles. 1 followers. laredotornado (869) is leader. Post Follow

35 Replies
6986 Views

Similar Articles

[PageSpeed] 31

On Mon, 28 Dec 2009 16:22:21 -0800 (PST), JRough wrote:
> I got this error starting mysql from installation:
> sh-3.2# /usr/local/mysql/bin/mysql -user=mysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/mysql/mysql.sock' (2)
> The same goes for starting as root.
>
> I do the
> sh-3.2# find ~ -name mysql.sock on my home directory,
> find . -name mysql.sock in the /usr/local directory and,
> find / -name mysql.sock and don't get a response.
>
> I haven't gotten the mysqld started once from the installation.
> I removed the other installations.
>
> MY.CONF:
> [client]
> socket=/var/mysql/mysql.sock
>
> PHP.INI
> ; Default socket name for local MySQL connects.  If empty, uses the
> built-in
> ; MySQL defaults.
> mysql.default_socket =  /var/mysql/mysql.sock
>
>
> The entire MY.CONF
> [mysqld]
> #Path to installation directory. All paths are usually resolved
> relative to this.
> basedir=/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/
> #Path to the database root
> datadir=/usr/local/mysql-5.1.40-osx10.5-powerpc/data
> #Path to the temporary directory.
> tmpdir=/private/tmp
> #The size of the buffer used for index blocks. Increase this to get
> better index handling (for all reads and multiple writes) to as much
> as you can afford; 64M on a 256M machine that mainly runs MySQL is
> quite common.
> key_buffer_size=8192k
> #Each thread that needs to do a sort allocates a buffer of this size.
> sort_buffer_size=2M
> #If no specific storage engine/table type is defined in an SQL-Create
> statement the default type will be used.
> default-storage-engine=myisam
> [client]
> socket=/var/mysql/mysql.sock
>
> Why does it think there are two mysql.sock?
> thanks,

Where are you starting the server? "mysql" including
"/usr/local/mysql/bin/mysql" are the CLIENT. "mysqld" (and its assorted
wrappers including mysqld_safe) are the server. Need both.

-- 
86. I will make sure that my doomsday device is up to code and properly 
    grounded.
	--Peter Anspach's list of things to do as an Evil Overlord
0
Peter
12/29/2009 12:30:27 AM
On Dec 28, 4:22=A0pm, JRough <jlro...@yahoo.com> wrote:
> I got this error starting mysql from installation:
> sh-3.2# /usr/local/mysql/bin/mysql -user=3Dmysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/mysql/mysql.sock' (2)
> The same goes for starting as root.
>
> I do the
> sh-3.2# find ~ -name mysql.sock on my home directory,
> find . -name mysql.sock in the /usr/local directory and,
> find / -name mysql.sock and don't get a response.
>
> I haven't gotten the mysqld started once from the installation.
> I removed the other installations.
>
> MY.CONF:
> [client]
> socket=3D/var/mysql/mysql.sock
>
> PHP.INI
> ; Default socket name for local MySQL connects. =A0If empty, uses the
> built-in
> ; MySQL defaults.
> mysql.default_socket =3D =A0/var/mysql/mysql.sock
>
> The entire MY.CONF
> [mysqld]
> #Path to installation directory. All paths are usually resolved
> relative to this.
> basedir=3D/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/
> #Path to the database root
> datadir=3D/usr/local/mysql-5.1.40-osx10.5-powerpc/data
> #Path to the temporary directory.
> tmpdir=3D/private/tmp
> #The size of the buffer used for index blocks. Increase this to get
> better index handling (for all reads and multiple writes) to as much
> as you can afford; 64M on a 256M machine that mainly runs MySQL is
> quite common.
> key_buffer_size=3D8192k
> #Each thread that needs to do a sort allocates a buffer of this size.
> sort_buffer_size=3D2M
> #If no specific storage engine/table type is defined in an SQL-Create
> statement the default type will be used.
> default-storage-engine=3Dmyisam
> [client]
> socket=3D/var/mysql/mysql.sock
>
> Why does it think there are two mysql.sock?
> thanks,

Maybe I was doing it as the wrong user?  I did this and got a
different message.
sh-3.2# ./bin/mysqld --user=3D_mysql
091228 16:50:37 [ERROR] Can't find messagefile '/usr/local/
mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'
091228 16:50:37 [Warning] Setting lower_case_table_names=3D2 because
file system for /usr/local/mysql-5.1.40-osx10.5-powerpc/data/ is case
insensitive
091228 16:50:37 [Note] Plugin 'FEDERATED' is disabled.
../bin/mysqld: Unknown error 1146
091228 16:50:37 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
091228 16:50:38  InnoDB: Started; log sequence number 0 44233
091228 16:50:38 [ERROR] Aborting

091228 16:50:38  InnoDB: Starting shutdown...
091228 16:50:39  InnoDB: Shutdown completed; log sequence number 0
44233
091228 16:50:39 [Note]

What is the mysql_update and the federated plugin?
0
JRough
12/29/2009 12:54:57 AM
On Dec 28, 4:22=A0pm, JRough <jlro...@yahoo.com> wrote:
> I got this error starting mysql from installation:
> sh-3.2# /usr/local/mysql/bin/mysql -user=3Dmysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/mysql/mysql.sock' (2)
> The same goes for starting as root.
>
> I do the
> sh-3.2# find ~ -name mysql.sock on my home directory,
> find . -name mysql.sock in the /usr/local directory and,
> find / -name mysql.sock and don't get a response.
>
> I haven't gotten the mysqld started once from the installation.
> I removed the other installations.
>
> MY.CONF:
> [client]
> socket=3D/var/mysql/mysql.sock
>
> PHP.INI
> ; Default socket name for local MySQL connects. =A0If empty, uses the
> built-in
> ; MySQL defaults.
> mysql.default_socket =3D =A0/var/mysql/mysql.sock
>
> The entire MY.CONF
> [mysqld]
> #Path to installation directory. All paths are usually resolved
> relative to this.
> basedir=3D/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/
> #Path to the database root
> datadir=3D/usr/local/mysql-5.1.40-osx10.5-powerpc/data
> #Path to the temporary directory.
> tmpdir=3D/private/tmp
> #The size of the buffer used for index blocks. Increase this to get
> better index handling (for all reads and multiple writes) to as much
> as you can afford; 64M on a 256M machine that mainly runs MySQL is
> quite common.
> key_buffer_size=3D8192k
> #Each thread that needs to do a sort allocates a buffer of this size.
> sort_buffer_size=3D2M
> #If no specific storage engine/table type is defined in an SQL-Create
> statement the default type will be used.
> default-storage-engine=3Dmyisam
> [client]
> socket=3D/var/mysql/mysql.sock
>
> Why does it think there are two mysql.sock?
> thanks,

Well I might have started the server.  Thanks
 jlrough$ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
Password:
Starting MySQL database server

however, to double-check I did ps aux | grep mysql   to see if it
started a process and I didn't see any mysql processes?
MySQLAdmin connection dialog said starting database server and I
didn't get an error message but that is the startup item alias .  I
did open MySQLAdministrator to see if I had a MySQL instance and it
said could not connect however it tried to connect to the old socket
in /tmp/mysql.sock .  the exact message is
"Could not connect to MySQL instance at localhost.  Canot connect to
local mysql server through socket 'tmp/mysql.sock(2)"
How can I tell if a old mysql.sock is in /tmp/mysql.sock

I tried mysqld and got the message above:
sh-3.2# /usr/local/mysql/bin/mysqld
091228 18:01:29 [ERROR] Can't find messagefile '/usr/local/
mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'
091228 18:01:29 [Warning] Setting lower_case_table_names=3D2 because
file system for /usr/local/mysql-5.1.40-osx10.5-powerpc/data/ is case
insensitive
091228 18:01:29 [ERROR] Fatal error: Please read "Security" section of
the manual to find out how to run mysqld as root!

091228 18:01:29 [ERROR] Aborting

091228 18:01:29 [Note]
sh-3.2#

When I start mysqld it seems to die.
sh-3.2# ./bin/mysqld_safe &
[1] 1722
sh-3.2# 091228 18:03:05 mysqld_safe Logging to '/usr/local/
mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-
g5.local.err'.
091228 18:03:06 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc/data
091228 18:03:07 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
ended

thanks,

What am I looking for?  In /private/tmp   there is no mysql.sock.  No
hidden files nothing.
0
JRough
12/29/2009 2:04:01 AM
On Mon, 28 Dec 2009 18:04:01 -0800 (PST), JRough wrote:
> On Dec 28, 4:22�pm, JRough <jlro...@yahoo.com> wrote:
>> PHP.INI
>> ; Default socket name for local MySQL connects. �If empty, uses the
>> built-in
>> ; MySQL defaults.
>> mysql.default_socket = �/var/mysql/mysql.sock
>>
>> The entire MY.CONF
>> [mysqld]
>> #Path to installation directory. All paths are usually resolved
>> relative to this.
>> basedir=/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/
>> #Path to the database root
>> datadir=/usr/local/mysql-5.1.40-osx10.5-powerpc/data
>> #Path to the temporary directory.
>> tmpdir=/private/tmp
>> #The size of the buffer used for index blocks. Increase this to get
>> better index handling (for all reads and multiple writes) to as much
>> as you can afford; 64M on a 256M machine that mainly runs MySQL is
>> quite common.
>> key_buffer_size=8192k
>> #Each thread that needs to do a sort allocates a buffer of this size.
>> sort_buffer_size=2M
>> #If no specific storage engine/table type is defined in an SQL-Create
>> statement the default type will be used.
>> default-storage-engine=myisam
>> [client]
>> socket=/var/mysql/mysql.sock
>>
>> Why does it think there are two mysql.sock?
>> thanks,
>
> Well I might have started the server.  Thanks
>  jlrough$ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
> Password:
> Starting MySQL database server
>
> however, to double-check I did ps aux | grep mysql   to see if it
> started a process and I didn't see any mysql processes?
> MySQLAdmin connection dialog said starting database server and I
> didn't get an error message but that is the startup item alias .  I
> did open MySQLAdministrator to see if I had a MySQL instance and it
> said could not connect however it tried to connect to the old socket
> in /tmp/mysql.sock .  the exact message is
> "Could not connect to MySQL instance at localhost.  Canot connect to
> local mysql server through socket 'tmp/mysql.sock(2)"
> How can I tell if a old mysql.sock is in /tmp/mysql.sock
>
> I tried mysqld and got the message above:
> sh-3.2# /usr/local/mysql/bin/mysqld
> 091228 18:01:29 [ERROR] Can't find messagefile '/usr/local/
> mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'
> 091228 18:01:29 [Warning] Setting lower_case_table_names=2 because
> file system for /usr/local/mysql-5.1.40-osx10.5-powerpc/data/ is case
> insensitive
> 091228 18:01:29 [ERROR] Fatal error: Please read "Security" section of
> the manual to find out how to run mysqld as root!
>
> 091228 18:01:29 [ERROR] Aborting
>
> 091228 18:01:29 [Note]
> sh-3.2#
>
> When I start mysqld it seems to die.

Yup. It started and kersploded. 

> sh-3.2# ./bin/mysqld_safe &
> [1] 1722
> sh-3.2# 091228 18:03:05 mysqld_safe Logging to '/usr/local/
> mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-
> g5.local.err'.
> 091228 18:03:06 mysqld_safe Starting mysqld daemon with databases
> from /usr/local/mysql-5.1.40-osx10.5-powerpc/data
> 091228 18:03:07 mysqld_safe mysqld from pid file /usr/local/
> mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
> ended

This is a separate run. What does the error log say THIS time? (If you don't
know where it logs, specify temporarily with --log-error=/path/to/file
on the mysqld_safe. 

> thanks,
>
> What am I looking for?  In /private/tmp   there is no mysql.sock.  No
> hidden files nothing.


It ain't gonna be there. Both the server and client are configured (per
your first post) to look in /var/mysql/mysql.sock for the socket.

-- 
"Doesn't everybody?" is a question that never expects an answer of "No."
0
Peter
12/29/2009 2:47:36 AM
> > When I start mysqld it seems to die.
>
> Yup. It started and kersploded.
>
> > sh-3.2# ./bin/mysqld_safe &
> > [1] 1722
> > sh-3.2# 091228 18:03:05 mysqld_safe Logging to '/usr/local/
> > mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-
> > g5.local.err'.
> > 091228 18:03:06 mysqld_safe Starting mysqld daemon with databases
> > from /usr/local/mysql-5.1.40-osx10.5-powerpc/data
> > 091228 18:03:07 mysqld_safe mysqld from pid file /usr/local/
> > mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
> > ended
>
> This is a separate run. What does the error log say THIS time? (If you do=
n't
> know where it logs, specify temporarily with --log-error=3D/path/to/file
> on the mysqld_safe.

I believe this is the error log.  It looks like the output of a
previous message but I checked the time of the log.

091228 20:03:39 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc/data
091228 20:03:39 [ERROR] Can't find messagefile '/usr/local/
mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'
091228 20:03:39 [Warning] Setting lower_case_table_names=3D2 because
file system for /usr/local/mysql-5.1.40-osx10.5-powerpc/data/ is case
insensitive
091228 20:03:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Unknown error 1146
091228 20:03:39 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
091228 20:03:39  InnoDB: Started; log sequence number 0 44233
091228 20:03:39 [ERROR] Aborting

091228 20:03:39  InnoDB: Starting shutdown...
091228 20:03:40  InnoDB: Shutdown completed; log sequence number 0
44233
091228 20:03:40 [Note]
091228 20:03:41 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
ended
~

~
"logs.err" 13L, 959C

> > thanks,
>
> > What am I looking for? =A0In /private/tmp =A0 there is no mysql.sock. =
=A0No
> > hidden files nothing.
>
> It ain't gonna be there. Both the server and client are configured (per
> your first post) to look in /var/mysql/mysql.sock for the socket.

Well the MySQL admin was looking for it in the previous location.
Should I uninstall it or will it find the right one as soon as it is
working.  At this point I don't care I just want to get mysql started.


thanks,

1
JRough
12/29/2009 4:08:43 AM
On Dec 28, 8:08=A0pm, JRough <jlro...@yahoo.com> wrote:
> > > When I start mysqld it seems to die.
>
> > Yup. It started and kersploded.
>
> > > sh-3.2# ./bin/mysqld_safe &
> > > [1] 1722
> > > sh-3.2# 091228 18:03:05 mysqld_safe Logging to '/usr/local/
> > > mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-
> > > g5.local.err'.
> > > 091228 18:03:06 mysqld_safe Starting mysqld daemon with databases
> > > from /usr/local/mysql-5.1.40-osx10.5-powerpc/data
> > > 091228 18:03:07 mysqld_safe mysqld from pid file /usr/local/
> > > mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
> > > ended
>
> > This is a separate run. What does the error log say THIS time? (If you =
don't
> > know where it logs, specify temporarily with --log-error=3D/path/to/fil=
e
> > on the mysqld_safe.
>
> I believe this is the error log. =A0It looks like the output of a
> previous message but I checked the time of the log.
>
> 091228 20:03:39 mysqld_safe Starting mysqld daemon with databases
> from /usr/local/mysql-5.1.40-osx10.5-powerpc/data
> 091228 20:03:39 [ERROR] Can't find messagefile '/usr/local/
> mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'
> 091228 20:03:39 [Warning] Setting lower_case_table_names=3D2 because
> file system for /usr/local/mysql-5.1.40-osx10.5-powerpc/data/ is case
> insensitive
> 091228 20:03:39 [Note] Plugin 'FEDERATED' is disabled.
> /usr/local/mysql/bin/mysqld: Unknown error 1146
> 091228 20:03:39 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 091228 20:03:39 =A0InnoDB: Started; log sequence number 0 44233
> 091228 20:03:39 [ERROR] Aborting
>
> 091228 20:03:39 =A0InnoDB: Starting shutdown...
> 091228 20:03:40 =A0InnoDB: Shutdown completed; log sequence number 0
> 44233
> 091228 20:03:40 [Note]
> 091228 20:03:41 mysqld_safe mysqld from pid file /usr/local/
> mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
> ended
> ~
>
> ~
> "logs.err" 13L, 959C
>
> > > thanks,
>
> > > What am I looking for? =A0In /private/tmp =A0 there is no mysql.sock.=
 =A0No
> > > hidden files nothing.
>
> > It ain't gonna be there. Both the server and client are configured (per
> > your first post) to look in /var/mysql/mysql.sock for the socket.
>
> Well the MySQL admin was looking for it in the previous location.
> Should I uninstall it or will it find the right one as soon as it is
> working. =A0At this point I don't care I just want to get mysql started.
>
> thanks,

Is mysql 5.1.40 built for Innodb engine?  That is a guess.  In my.conf
it says default type is myisam.  Could that cause it to not be able to
find this plug-in or something?
default-storage-engine=3Dmyisam
[client]
socket=3D/var/mysql/mysql.sock
1
JRough
12/29/2009 4:26:47 AM
Did you set up a plist?

Suggest you take a look at this site- you don't need to compile the 
MySQL- but the part about creating a plist is useful.

http://hivelogic.com/articles/compiling-mysql-on-snow-leopard/
1
Banana
12/29/2009 4:48:26 AM
On Dec 28, 8:48=A0pm, Banana <Ban...@Republic.com> wrote:
> Did you set up a plist?
>
> Suggest you take a look at this site- you don't need to compile the
> MySQL- but the part about creating a plist is useful.
>
> http://hivelogic.com/articles/compiling-mysql-on-snow-leopard/

I tried to compile from source and it didn't work so I tried the
installer.  That didn't work.  I only have 32 bit g5 not an Intel
Mac.  I don't know if the older machine is an issue.  I will try
installing Snow L:eopard on it and see if I can compile from source.
It has been a big pain.  Back to square one again.  I should have left
Tiger and MySQL on it but I didn't have the command line.  The Mac
preinstalled version of mysql doesn't have the command line.
1
JRough
12/29/2009 8:23:55 PM
On Dec 28, 8:48=A0pm, Banana <Ban...@Republic.com> wrote:
> Did you set up a plist?
>
> Suggest you take a look at this site- you don't need to compile the
> MySQL- but the part about creating a plist is useful.
>
> http://hivelogic.com/articles/compiling-mysql-on-snow-leopard/

that is the mac version of MySQL on Leopard which wrote over the
version that worked on Tiger.
1
JRough
12/29/2009 8:24:36 PM
JRough wrote:
> On Dec 28, 8:48 pm, Banana <Ban...@Republic.com> wrote:
>> Did you set up a plist?
>>
>> Suggest you take a look at this site- you don't need to compile the
>> MySQL- but the part about creating a plist is useful.
>>
>> http://hivelogic.com/articles/compiling-mysql-on-snow-leopard/
> 
> I tried to compile from source and it didn't work so I tried the
> installer.  That didn't work.  I only have 32 bit g5 not an Intel
> Mac.  I don't know if the older machine is an issue.  I will try
> installing Snow L:eopard on it and see if I can compile from source.
> It has been a big pain.  Back to square one again.  I should have left
> Tiger and MySQL on it but I didn't have the command line.  The Mac
> preinstalled version of mysql doesn't have the command line.

1) There are no such thing as 32-bit G5 processor. If you have a G5, 
then it's a 64-bit. If you meant G4, then that's what you have. Double 
check this to be sure you're using the right bit-size.

2) You can't install Snow Leopard on a PPC machine. It's intel-only.

3) Is there a reason for compiling from source? You should be able to 
use the binary. Leopard has changed the way MySQL starts up and hence 
requires the plist fix I linked you to.
1
Banana
12/29/2009 9:00:36 PM
JRough <jlrough@yahoo.com> writes:

> I only have 32 bit g5

No such animal - G5s are 64-bit.

> I don't know if the older machine is an issue.

It's not. I'm running the latest MySQL on a ten year old G4.

> I will try installing Snow Leopard on it

Snow Leopard requires an Intel Mac.

> The Mac
> preinstalled version of mysql doesn't have the command line.

If you're referring to Mac OS X Server, yes it does. It's not in your
default PATH, but it's there.

sherm--
1
Sherm
12/29/2009 9:16:23 PM
On Dec 29, 1:16=A0pm, Sherm Pendley <spamt...@shermpendley.com> wrote:
> JRough <jlro...@yahoo.com> writes:
> > I only have 32 bit g5
>
> No such animal - G5s are 64-bit.
>
> > I don't know if the older machine is an issue.
>
> It's not. I'm running the latest MySQL on a ten year old G4.
>
> > I will try installing Snow Leopard on it
>
> Snow Leopard requires an Intel Mac.
>
> > The Mac
> > preinstalled version of mysql doesn't have the command line.
>
> If you're referring to Mac OS X Server, yes it does. It's not in your
> default PATH, but it's there.
>
> sherm--

Well I didn't know the specs on the g5.  You might have solved my
problems.  I do have an intel macbook pro but don't want to install
mysql server on it for security reasons but I will if I have to.
Thanks though I will give it one more try on the g5.
0
JRough
12/29/2009 10:48:12 PM
On Dec 29, 1:16=A0pm, Sherm Pendley <spamt...@shermpendley.com> wrote:
> JRough <jlro...@yahoo.com> writes:
> > I only have 32 bit g5
>
> No such animal - G5s are 64-bit.
>
> > I don't know if the older machine is an issue.
>
> It's not. I'm running the latest MySQL on a ten year old G4.
>
> > I will try installing Snow Leopard on it
>
> Snow Leopard requires an Intel Mac.
>
> > The Mac
> > preinstalled version of mysql doesn't have the command line.
>
> If you're referring to Mac OS X Server, yes it does. It's not in your
> default PATH, but it's there.
>
> sherm--
I tried reinstalling from the  package file.  No compile just regular
install.  I checked a mysql user and group are created.
I got this in the error log:
91229 17:42:41 mysqld_safe Starting mysqld daemon with databases from /
usr/local/mysql-5.1.40-osx10.5-powerpc/data
091229 17:42:41 [ERROR] Can't find messagefile '/usr/local/
mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'
091229 17:42:41 [Warning] Can't create test file /usr/local/
mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.lower-test
091229 17:42:41 [Warning] Can't create test file /usr/local/
mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.lower-test
^G/usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
mysql-5.1.40-osx10.5-powerpc/data/' (Errcode: 2)
091229 17:42:41 [ERROR] Aborting

091229 17:42:41 [Note]
091229 17:42:41 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
ended

Who should the data directory be owned by?  I have it owned by mysql
user.  I tried starting mysqld_safe as root and as mysql to see if it
made a difference and I got the same errors.

please help
0
JRough
12/30/2009 1:52:40 AM
On Dec 29, 1:16=A0pm, Sherm Pendley <spamt...@shermpendley.com> wrote:
> JRough <jlro...@yahoo.com> writes:
> > I only have 32 bit g5
>
> No such animal - G5s are 64-bit.
>
> > I don't know if the older machine is an issue.
>
> It's not. I'm running the latest MySQL on a ten year old G4.
>
> > I will try installing Snow Leopard on it
>
> Snow Leopard requires an Intel Mac.
>
> > The Mac
> > preinstalled version of mysql doesn't have the command line.
>
> If you're referring to Mac OS X Server, yes it does. It's not in your
> default PATH, but it's there.
>
> sherm--

Do you have tiger or leopard on your g4?  I had tiger working.  I
think I had Leopard working without the command line.  Now nothing
works.  I think it was the preinstalled mysql version that comes with
Leopard.
0
JRough
12/30/2009 1:54:19 AM
JRough <jlrough@yahoo.com> writes:

> I got this in the error log:
> 91229 17:42:41 mysqld_safe Starting mysqld daemon with databases from /
> usr/local/mysql-5.1.40-osx10.5-powerpc/data
> 091229 17:42:41 [ERROR] Can't find messagefile '/usr/local/
> mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'

Does /usr/local/mysql-5.1.40-osx10.5-powerpc/ exist? If not, and if
/usr/local/mysql/ *does*, then a symlink should fix things up:

    cd /usr/local
    sudo ln -s ./mysql ./mysql-5.1.40-osx10.5-powerpc

I've seen this kind of problem before on Mac OS X versions of MySQL,
where the MySQL tools were configured to use the longer path, but the
installer package placed files in /usr/local/mysql instead.

sherm--
0
Sherm
12/30/2009 4:13:58 AM
JRough <jlrough@yahoo.com> writes:

> On Dec 29, 1:16�pm, Sherm Pendley <spamt...@shermpendley.com> wrote:
>> JRough <jlro...@yahoo.com> writes:
>> > I only have 32 bit g5
>>
>> No such animal - G5s are 64-bit.
>>
>> > I don't know if the older machine is an issue.
>>
>> It's not. I'm running the latest MySQL on a ten year old G4.
>>
>> > I will try installing Snow Leopard on it
>>
>> Snow Leopard requires an Intel Mac.
>>
>> > The Mac
>> > preinstalled version of mysql doesn't have the command line.
>>
>> If you're referring to Mac OS X Server, yes it does. It's not in your
>> default PATH, but it's there.
>
> Do you have tiger or leopard on your g4?

Leopard, although I've had MySQL working on it since the 4th Developer
Preview release of Mac OS X 10.0. You kids today have it easy - in MY
day we had to edit the source code just to get it to compile! Grumble,
grumble, uphill both ways, grumble... :-)

> I think it was the preinstalled mysql version that comes with
> Leopard.

Only Mac OS X Server includes MySQL. If you don't have Server, it wasn't
preinstalled.

sherm--
0
Sherm
12/30/2009 4:22:01 AM
JRough <jlrough@yahoo.com> writes:

> I tried reinstalling from the  package file.

*What* package file? Did you download it from mysql.com?

> 091229 17:42:41 [ERROR] Can't find messagefile '/usr/local/
> mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'

That's bizarre. It should be looking for share/english/errmsg.sys here,
not bin/share/english/errmsg.sys. The required file is in the package
I just now downloaded from mysql.com, and installed to the correct
spot, but mysqld is looking in the wrong place for it.

sherm--
0
Sherm
12/30/2009 4:33:09 AM
Sherm Pendley <spamtrap@shermpendley.com> writes:

> JRough <jlrough@yahoo.com> writes:
>
>> I tried reinstalling from the  package file.
>
> *What* package file? Did you download it from mysql.com?
>
>> 091229 17:42:41 [ERROR] Can't find messagefile '/usr/local/
>> mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'
>
> That's bizarre. It should be looking for share/english/errmsg.sys here,
> not bin/share/english/errmsg.sys. The required file is in the package
> I just now downloaded from mysql.com, and installed to the correct
> spot, but mysqld is looking in the wrong place for it.

Okay, earlier in the thread you posted a my.conf that includes this:

    #Path to installation directory. All paths are usually resolved
    #relative to this.
    basedir=/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/

Notice what it says in the comment? When mysqld is starting up, it's
looking for share/english/errmsg.sys *relative to the basedir* - that's
where the incorrect bin/ is coming from.

sherm--
0
Sherm
12/30/2009 4:40:38 AM
>
> Okay, earlier in the thread you posted a my.conf that includes this:
>
> =A0 =A0 #Path to installation directory. All paths are usually resolved
> =A0 =A0 #relative to this.
> =A0 =A0 basedir=3D/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/
>
> Notice what it says in the comment? When mysqld is starting up, it's
> looking for share/english/errmsg.sys *relative to the basedir* - that's
> where the incorrect bin/ is coming from.
>
> sherm--

Okay, thanks, very much I forgot to change my.conf.   I took out the
extra bin and I  changed the directory name to match the new install
pkg.  Thankfully it is not saying a missing federated plug-in or can't
find the mysql.sock anymore :-)


Is it working?    I didn't start with mysql user but I guess it
started that way on its own?
sh-3.2# ps aux | grep mysql
_mysql   64825   9.4  0.0    75944    744   ??  Rs   10:20AM
0:00.03 /bin/sh /usr/local/mysql/bin/mysqld_safe
_mysql   63487   0.0  0.0    75488    476   ??  Ss   10:18AM
0:00.05 /sbin/launchd

One last problem.  I can't get mysqladmin to run.
/usr/local/mysql/bin/mysqladmin
gets a canned man page.
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf
The following groups are read: mysqladmin client..............etc etc



Why doesn't mysqladmin CLI work?  I can't get it to connect with the
MySQL Administrator app either.  Is this something to do with
[client] in my.conf?  What do I put in there?  Is that why it doesn't
work?

thanks again,
0
JRough
12/30/2009 6:55:36 PM
JRough wrote:
> Is it working? 

If you can connect via mysql client, then it's working.

> One last problem.  I can't get mysqladmin to run.
> /usr/local/mysql/bin/mysqladmin
> gets a canned man page.

Pretty sure that mysqladmin isn't interactive- you should pass in 
commands & options and it'd do stuff. If you want interactive session, 
use mysql client, or GUI tool.
0
Banana
12/30/2009 7:04:18 PM
Banana <Banana@Republic.com> writes:

> JRough wrote:
>> Is it working? 
>
> If you can connect via mysql client, then it's working.

Yep. The absence of any error messages is a good sign though!

>> One last problem.  I can't get mysqladmin to run.
>> /usr/local/mysql/bin/mysqladmin
>> gets a canned man page.
>
> Pretty sure that mysqladmin isn't interactive- you should pass in
> commands & options and it'd do stuff.

You're right, mysqladmin isn't an interactive shell. The help page lists
the available commands and options that can be given as arguments when
you run it.

sherm--
0
Sherm
12/30/2009 7:15:08 PM
On Dec 29, 8:40=A0pm, Sherm Pendley <spamt...@shermpendley.com> wrote:
> Sherm Pendley <spamt...@shermpendley.com> writes:
> > JRough <jlro...@yahoo.com> writes:
>
> >> I tried reinstalling from the =A0package file.
>
> > *What* package file? Did you download it from mysql.com?
>
> >> 091229 17:42:41 [ERROR] Can't find messagefile '/usr/local/
> >> mysql-5.1.40-osx10.5-powerpc/bin/share/english/errmsg.sys'
>
> > That's bizarre. It should be looking for share/english/errmsg.sys here,
> > not bin/share/english/errmsg.sys. The required file is in the package
> > I just now downloaded from mysql.com, and installed to the correct
> > spot, but mysqld is looking in the wrong place for it.
>
> Okay, earlier in the thread you posted a my.conf that includes this:
>
> =A0 =A0 #Path to installation directory. All paths are usually resolved
> =A0 =A0 #relative to this.
> =A0 =A0 basedir=3D/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/
>
> Notice what it says in the comment? When mysqld is starting up, it's
> looking for share/english/errmsg.sys *relative to the basedir* - that's
> where the incorrect bin/ is coming from.
>
> sherm--

I changed my.conf client to
[client]
/tmp/mysql.sock

I tried /usr/local/mysql/bin/mysqladmin -u root
and I just get the mysqladmin man page.

How do I ping MySQLServer?
thanks,
0
JRough
12/30/2009 7:15:49 PM
JRough wrote:
> I tried /usr/local/mysql/bin/mysqladmin -u root
> and I just get the mysqladmin man page.
> 
> How do I ping MySQLServer?
> thanks,

As explained previously, mysqladmin isn't interactive; you need to pass 
in the command... e.g.

mysqladmin ping -u root



(note the ping command being given after the mysqladmin -- read the man 
pages to see the rest of option and how it is to be used)
0
Banana
12/30/2009 7:21:00 PM
On Dec 30, 11:21=A0am, Banana <Ban...@Republic.com> wrote:
> JRough wrote:
> > I tried /usr/local/mysql/bin/mysqladmin -u root
> > and I just get the mysqladmin man page.
>
> > How do I ping MySQLServer?
> > thanks,
>
> As explained previously, mysqladmin isn't interactive; you need to pass
> in the command... e.g.
>
> mysqladmin ping -u root
>
> (note the ping command being given after the mysqladmin -- read the man
> pages to see the rest of option and how it is to be used)

I'm not sure mysql is really running.  What is /sbin/launchd for?
There is a mysql process but I don't know if it is the mysqld.  :-(
janis-roughs-power-mac-g5:bin jlrough$ !ps
ps aux | grep mysql
_mysql     106   0.0  0.0    75488    476   ??  Ss   12:42PM
0:05.72 /sbin/launchd

I pinged it and got the mysql.sock(2) error.  :-(
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/
mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock'
exists!


I tried to start mysqladmin with the socket and that failed.  I got
the man page again but it might not be running since I don't think the
demon is running.
 /usr/local/mysql/bin/mysqladmin -S -socket=3D/tmp/mysql.sock

Should I reinstall mysql yet again?  That will be painful since I
really don't know what is wrong.
Janis
0
JRough
12/31/2009 3:16:00 AM
JRough wrote:
> I'm not sure mysql is really running.  What is /sbin/launchd for?
> There is a mysql process but I don't know if it is the mysqld.  :-(
> janis-roughs-power-mac-g5:bin jlrough$ !ps
> ps aux | grep mysql
> _mysql     106   0.0  0.0    75488    476   ??  Ss   12:42PM
> 0:05.72 /sbin/launchd

launchd is Daemon manager for Mac OS X.

> I pinged it and got the mysql.sock(2) error.  :-(
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/tmp/
> mysql.sock' (2)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock'
> exists!

I would want to verify that the mysql.sock is actually in /tmp/ folder. 
Depending on how it was installed, it could have been in a different folder.

Alternatively, try this:

mysql -h 127.0.0.1 -u XXXX -p

to coerce connecting to MySQL via TCP/IP instead of socket (which I 
prefer for local connection but let's do one thing at a time-- this is 
to rule out missing socket file from a server that is not running).

Next point, I _think_ you are supposed to see a mysqld (note the d at 
the end). mysql would be just be a client. At least in my top & aux 
doesn't list mysql but rather mysqld.

> I tried to start mysqladmin with the socket and that failed.  I got
> the man page again but it might not be running since I don't think the
> demon is running.
>  /usr/local/mysql/bin/mysqladmin -S -socket=/tmp/mysql.sock

This only will succeed if there is an actual file named mysql.sock 
located in the /tmp folder. As explained above, if the installation 
configuration is different, it may be actually somewhere else.

The far more likely answer is that the mysql isn't up and running.

How did you start the server? Manually or automatically as a part of 
startup?

> Should I reinstall mysql yet again?  That will be painful since I
> really don't know what is wrong.
> Janis

I don't think so. See the above for possible troubleshooting steps.
0
Banana
12/31/2009 4:31:33 PM
> I would want to verify that the mysql.sock is actually in /tmp/ folder.
> Depending on how it was installed, it could have been in a different fold=
er.
>
> Alternatively, try this:
>
> mysql -h 127.0.0.1 -u XXXX -p
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -h 127.0.0.1 -u
root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -h 127.0.0.1 -u
mysql
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)

> to coerce connecting to MySQL via TCP/IP instead of socket (which I
> prefer for local connection but let's do one thing at a time-- this is
> to rule out missing socket file from a server that is not running).
>
> Next point, I _think_ you are supposed to see a mysqld (note the d at
> the end). mysql would be just be a client. At least in my top & aux
> doesn't list mysql but rather mysqld.
>
> > I tried to start mysqladmin with the socket and that failed. =A0I got
> > the man page again but it might not be running since I don't think the
> > demon is running.
> > =A0/usr/local/mysql/bin/mysqladmin -S -socket=3D/tmp/mysql.sock
>
> This only will succeed if there is an actual file named mysql.sock
> located in the /tmp folder. As explained above, if the installation
> configuration is different, it may be actually somewhere else.
I don't understand this mysql.sock when does it get installed at start
up or when mysql is installed?  Maybe I should change the my.conf and
the php.ini to be /var/msyql/mysql.sock to see if it works.  I looked
in there and don't see a file named mysql.sock.  I also looked in /
tmp/ and there is no file called mysql.sock.
php.ini:
 mysql.default_socket=3D /tmp/mysql.sock
My.conf :
[client]
socket=3D/tmp/mysql.sock
> The far more likely answer is that the mysql isn't up and running.
>
> How did you start the server? Manually or automatically as a part of
> startup?

I put the com.mysql.mysqld.plist from HiveLogic in /Library/
LaunchDaemons, http://hivelogic.com/articles/compiling-mysql-on-snow-leopar=
d/
the instructions are for compiled mysql with snow leopard but I only
used the plist instructions:
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ launchctl load -w /
Library/LaunchDaemons/com.mysql.mysqld.plist
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -u _mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

That was what the launchd was all about.  It was from the plist.
>
> > Should I reinstall mysql yet again? =A0That will be painful since I
> > really don't know what is wrong.
> > Janis
>
> I don't think so. See the above for possible troubleshooting steps.

Thanks,
0
JRough
12/31/2009 6:23:06 PM
JRough wrote:
> ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)

Okay, this does confirm that MySQL isn't running at all and this isn't a 
case of missing socket file or misconfiguration.

> I don't understand this mysql.sock when does it get installed at start
> up or when mysql is installed?  

It's just a file that tells the OS where to look for inter-process 
communication. UNIX and Unix-like systems uses sockets, which are small 
files that points to the memory address of the process for entry points.


Maybe I should change the my.conf and
> the php.ini to be /var/msyql/mysql.sock to see if it works. 

No. Your MySQL server is looking in /tmp/mysql.sock so that's where it 
expects it to be. If your configuration files already points to 
/tmp/mysql.sock, then this is correct.



Apologies if I've missed this but did you already try running 
mysqld_safe? Furthermore, did you do this as an administrator?

For example, I usually do this:

su admin -c 'sudo /usr/local/mysql/bin/mysqld_safe'

where 'admin' is my Administrator account's short name. Your 
administrator account may be named differently, so change that 
accordingly. You would then enter the administrator's password twice 
(yes, twice). See if this succeed, then we can move further in fixing 
the startup issues.
0
Banana
12/31/2009 6:37:09 PM
On Dec 31, 10:37=A0am, Banana <Ban...@Republic.com> wrote:
> JRough wrote:
> > ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
>
> Okay, this does confirm that MySQL isn't running at all and this isn't a
> case of missing socket file or misconfiguration.
>
> > I don't understand this mysql.sock when does it get installed at start
> > up or when mysql is installed? =A0
>
> It's just a file that tells the OS where to look for inter-process
> communication. UNIX and Unix-like systems uses sockets, which are small
> files that points to the memory address of the process for entry points.
>
> Maybe I should change the my.conf and
>
> > the php.ini to be /var/msyql/mysql.sock to see if it works.
>
> No. Your MySQL server is looking in /tmp/mysql.sock so that's where it
> expects it to be. If your configuration files already points to
> /tmp/mysql.sock, then this is correct.
>
> Apologies if I've missed this but did you already try running
> mysqld_safe? Furthermore, did you do this as an administrator?
>
> For example, I usually do this:
>
> su admin -c 'sudo /usr/local/mysql/bin/mysqld_safe'
>
> where 'admin' is my Administrator account's short name. Your
> administrator account may be named differently, so change that
> accordingly. You would then enter the administrator's password twice
> (yes, twice). See if this succeed, then we can move further in fixing
> the startup issues.

I couldn't su as admin and start it for some reason.  presumably
because I have to set the grant tables.  I tried to start it as mysql
and I tried to start it as root.  I couldn't find a mysqld process.
Starting as root I got the starting message but it doesn't seem to
finish.  All the mysql directories are owned by root except for the
data directory is owned by mysql.

h-3.2# /usr/local/mysql/bin/mysqld_safe
091231 14:22:06 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
091231 14:22:06 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
091231 14:22:07 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
sh-3.2# ps aux | grep mysql
_mysql     106   0.0  0.0    75488    476   ??  Ss   Wed12PM
0:18.36 /sbin/launchd
root     40913   0.0  0.0    75516    484 s002  S+    2:23PM   0:00.01
grep mysql
sh-3.2# su admin -c 'sudo /usr/local/mysql/bin/mysqld_safe'
su: unknown login: admin
sh-3.2# su mysql -c 'sudo /usr/local/mysql/bin/mysqld_safe'
sh-3.2# ps aux | grep mysql
_mysql     106   0.0  0.0    75488    476   ??  Ss   Wed12PM
0:18.38 /sbin/launchd
thanks,
0
JRough
12/31/2009 10:28:29 PM
On Dec 31, 10:37=A0am, Banana <Ban...@Republic.com> wrote:
> JRough wrote:
> > ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
>
> Okay, this does confirm that MySQL isn't running at all and this isn't a
> case of missing socket file or misconfiguration.
>
> > I don't understand this mysql.sock when does it get installed at start
> > up or when mysql is installed? =A0
>
> It's just a file that tells the OS where to look for inter-process
> communication. UNIX and Unix-like systems uses sockets, which are small
> files that points to the memory address of the process for entry points.
>
> Maybe I should change the my.conf and
>
> > the php.ini to be /var/msyql/mysql.sock to see if it works.
>
> No. Your MySQL server is looking in /tmp/mysql.sock so that's where it
> expects it to be. If your configuration files already points to
> /tmp/mysql.sock, then this is correct.
>
> Apologies if I've missed this but did you already try running
> mysqld_safe? Furthermore, did you do this as an administrator?
>
> For example, I usually do this:
>
> su admin -c 'sudo /usr/local/mysql/bin/mysqld_safe'
>
> where 'admin' is my Administrator account's short name. Your
> administrator account may be named differently, so change that
> accordingly. You would then enter the administrator's password twice
> (yes, twice). See if this succeed, then we can move further in fixing
> the startup issues.

P.S.  I tried it with my User name in system  preferences also.  I
think that is the short name.  Anyway it is the user name and it is
the admin account name as well.  I got the same response.

anis-roughs-power-mac-g5:~ jlrough$ su jlrough -c 'sudo /usr/local/
mysql/bin/mysqld_safe'
Password:
Password:
091231 14:38:00 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
091231 14:38:00 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
091231 14:38:00 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
janis-roughs-power-mac-g5:~ jlrough$ ps aux | grep mysql
_mysql     106   0.0  0.0    75488    476   ??  Ss   Wed12PM
0:18.59 /sbin/launchd
janis-roughs-power-mac-g5:~ jlrough$
0
JRough
12/31/2009 10:40:27 PM
>
> > Apologies if I've missed this but did you already try running
> > mysqld_safe? Furthermore, did you do this as an administrator?
>
> > For example, I usually do this:
>
> > su admin -c 'sudo /usr/local/mysql/bin/mysqld_safe'
>
> > where 'admin' is my Administrator account's short name. Your
> > administrator account may be named differently, so change that
> > accordingly. You would then enter the administrator's password twice
> > (yes, twice). See if this succeed, then we can move further in fixing
> > the startup issues.
>
> I couldn't su as admin and start it for some reason. =A0presumably
> because I have to set the grant tables. =A0I tried to start it as mysql
> and I tried to start it as root. =A0I couldn't find a mysqld process.
> Starting as root I got the starting message but it doesn't seem to
> finish. =A0All the mysql directories are owned by root except for the
> data directory is owned by mysql.
>
> h-3.2# /usr/local/mysql/bin/mysqld_safe
> 091231 14:22:06 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
> osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
> 091231 14:22:06 mysqld_safe Starting mysqld daemon with databases
> from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
> 091231 14:22:07 mysqld_safe mysqld from pid file /usr/local/
> mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
> g5.local.pid ended
> sh-3.2# ps aux | grep mysql
> _mysql =A0 =A0 106 =A0 0.0 =A00.0 =A0 =A075488 =A0 =A0476 =A0 ?? =A0Ss =
=A0 Wed12PM
> 0:18.36 /sbin/launchd
> root =A0 =A0 40913 =A0 0.0 =A00.0 =A0 =A075516 =A0 =A0484 s002 =A0S+ =A0 =
=A02:23PM =A0 0:00.01
> grep mysql
> sh-3.2# su admin -c 'sudo /usr/local/mysql/bin/mysqld_safe'
> su: unknown login: admin
> sh-3.2# su mysql -c 'sudo /usr/local/mysql/bin/mysqld_safe'
> sh-3.2# ps aux | grep mysql
> _mysql =A0 =A0 106 =A0 0.0 =A00.0 =A0 =A075488 =A0 =A0476 =A0 ?? =A0Ss =
=A0 Wed12PM
> 0:18.38 /sbin/launchd
> thanks,

If my short name is in /Users/  then that is the last one I tried.
0
JRough
12/31/2009 11:45:05 PM

> 091231 14:38:00 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
> osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.

So,
what is in the error file?

R. 


0
Richard
1/1/2010 5:56:08 PM
On Jan 1, 9:56=A0am, "Richard" <root@localhost> wrote:
> > 091231 14:38:00 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
> > osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
>
> So,
> what is in the error file?
>
> R.

100104 20:20:27 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
100104 20:20:27 [Warning] Setting lower_case_table_names=3D2 because
file system for /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/ is
case insensitive
100104 20:20:27 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/bin/mysqld: Table
'mysql.plugin' doesn't exist
100104 20:20:27 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
100104 20:20:27  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the
doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
100104 20:20:28  InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89
90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
100104 20:20:28  InnoDB: Started; log sequence number 0 44233
100104 20:20:28 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
100104 20:20:28 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
0
JRough
1/5/2010 5:10:53 AM
On Jan 1, 9:56=A0am, "Richard" <root@localhost> wrote:
> > 091231 14:38:00 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
> > osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
>
> So,
> what is in the error file?
>
> R.
Wait a minute, I just started mysqld as _mysql user and directed the
error log to /Library/Logs.  Does it want me to change owner on
mysql.err to _mysql user?Is that the problem?  Is doesn't work as
starting with other users but the data directory belongs to _mysql so
it should start as _mysql right or root?

janis-roughs-power-mac-g5:mysql jlrough$ /usr/local/mysql/bin/
mysqld_safe --user=3D_mysql with --log-error=3D/Library/Logs/mysql.err
100104 21:46:58 mysqld_safe Logging to '/Library/Logs/mysql.err'.
chown: /Library/Logs/mysql.err: Operation not permitted
100104 21:46:58 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
rm: /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-
power-mac-g5.local.pid: Permission denied
100104 21:46:58 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
janis-roughs-power-mac-g5:mysql jlrough$


THIS IS MYSQL.err:
100104 21:46:58 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
100104 21:46:58 [Warning] Can't create test file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.lower-test
100104 21:46:58 [Warning] Can't create test file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.lower-test
^G/usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/' (Errcode: 13)
100104 21:46:58 [ERROR] Aborting

100104 21:46:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

100104 21:46:58 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
~
0
JRough
1/5/2010 5:58:54 AM
On Jan 1, 9:56=A0am, "Richard" <root@localhost> wrote:
> > 091231 14:38:00 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
> > osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
>
> So,
> what is in the error file?
>
> R.

When I just start as _mysql user without redirecting the error log to /
Library/Logs I get another error in the data directory which belongs
to _mysql user
-bash: /usr/local/mysql/bin/msyqld_safe: No such file or directory
janis-roughs-power-mac-g5:mysql jlrough$ /usr/local/mysql/bin/
mysqld_safe --user=3D_mysql
100104 22:08:04 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
touch: /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-
power-mac-g5.local.err: Permission denied
chown: /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-
power-mac-g5.local.err: Permission denied
100104 22:08:04 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err:
Permission denied
rm: /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-
power-mac-g5.local.pid: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 137: /usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err:
Permission denied
100104 22:08:04 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err:
Permission denied
janis-roughs-power-mac-g5:mysql jlrough$

So I don't know what I am supposed to change the owner as?
total 146400
drwxr-x---   9 _mysql  wheel       306 Jan  4 21:45 .
drwxr-xr-x  17 root    wheel       578 Oct  9 08:07 ..
-rw-r-----   1 root    wheel    241664 Jan  4 21:38 .janis-roughs-
power-mac-g5.local.err.swp
-rw-rw----   1 _mysql  wheel   5242880 Jan  4 21:37 ib_logfile0
-rw-rw----   1 _mysql  wheel   5242880 Dec 30 09:56 ib_logfile1
-rw-rw----   1 _mysql  wheel  10485760 Jan  4 21:37 ibdata1
-rw-rw----   1 _mysql  wheel  53743106 Jan  4 21:37 janis-roughs-power-
mac-g5.local.err
drwxr-x---   2 _mysql  wheel        68 Oct  9 08:07 mysql
drwxr-x---   2 _mysql  wheel        68 Oct  9 08:07 test
0
JRough
1/5/2010 6:11:37 AM
On Dec 30 2009, 11:15=A0am, Sherm Pendley <spamt...@shermpendley.com>
wrote:
> Banana <Ban...@Republic.com> writes:
> > JRough wrote:
> >> Is it working?
>
> > If you can connect via mysql client, then it's working.
>
> Yep. The absence of any error messages is a good sign though!
>
> >> One last problem. =A0I can't get mysqladmin to run.
> >> /usr/local/mysql/bin/mysqladmin
> >> gets a canned man page.
>
> > Pretty sure that mysqladmin isn't interactive- you should pass in
> > commands & options and it'd do stuff.
>
> You're right, mysqladmin isn't an interactive shell. The help page lists
> the available commands and options that can be given as arguments when
> you run it.
>
> sherm--
I need someone who knows macs and mysql and I don't want to start
another thread.  It would be great if I could finish it.  I think I
found the other mysql.sock.
It was on a 2nd hard drive.
I think most problems are fixed.  I think now the only problem is a
permissions issue with the _mysql user can't write to the error log.
It also seems to happen on the admin user as well.
sh-3.2# su jlrough -c 'sudo /usr/local/mysql/bin/mysqld_safe'
100105 17:10:55 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
100105 17:10:55 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
100105 17:10:56 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
osx10.5-powerpc-64bit/data/Library/Logs/.err: No such file or
directory
chown: /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/Library/
Logs/.err: No such file or directory
100105 16:57:47 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/Library/Logs/.err: No such file or
directory
/usr/local/mysql/bin/mysqld_safe: line 137: /usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/Library/Logs/.err: No such file or
directory
100105 16:57:47 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/Library/Logs/.err: No such file or
directory

I found the log file ,janis-roughs-power-mac-g5.local.err, here is the
latest entry for today:
100105 17:06:57 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
100105 17:06:57 [Warning] Setting lower_case_table_names=3D2 because
file system for /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/ is
case insensitive
100105 17:06:57 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
100105 17:06:57 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
100105 17:06:58  InnoDB: Started; log sequence number 0 44233
100105 17:06:58 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
100105 17:06:58 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
100105 17:10:55 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
100105 17:10:56 [Warning] Setting lower_case_table_names=3D2 because
file system for /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/ is
case insensitive
100105 17:10:56 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/bin/mysqld: Table
'mysql.plugin' doesn't exist
100105 17:10:56 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
100105 17:10:56  InnoDB: Started; log sequence number 0 44233
100105 17:10:56 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
100105 17:10:56 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
~

Here is the startup it with the _mysql user:
sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=3D_mysql
100105 17:17:29 mysqld_safe Logging to '/usr/local/mysql-5.1.40-
osx10.5-powerpc-64bit/data/janis-roughs-power-mac-g5.local.err'.
100105 17:17:29 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
100105 17:17:30 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
sh-3.2#
Here is the log file with the _mysql user:
100105 17:17:29 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data
100105 17:17:29 [Warning] Setting lower_case_table_names=3D2 because
file system for /usr/local/mysql-5.1.40-osx10.5-powerpc-64bit/data/ is
case insensitive
100105 17:17:29 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
100105 17:17:29 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
100105 17:17:30  InnoDB: Started; log sequence number 0 44233
100105 17:17:30 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
100105 17:17:30 mysqld_safe mysqld from pid file /usr/local/
mysql-5.1.40-osx10.5-powerpc-64bit/data/janis-roughs-power-mac-
g5.local.pid ended
~


0
JRough
1/6/2010 1:20:37 AM
Reply:

Similar Artilces:

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When i try to start my mysql server, i get this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I usualy start it witn /bin/mysql I use Fedora core 3 Cristi ...

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/custcare/dbconn.inc on line 2
It's really strange. I downloaded the latest 4.0.16 RPM from mysql.com and installed it to my Fedora system, and did *not* do anything else (Actually I am completely new to mysql). I wrote a test php script to test mysql (ftp_connect('localhost', 'root');), but got the following error: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/custcare/dbconn.inc on line 2 I ran phpBB2 installation page, got the same error. But it can connect to mysql using my computer name. Anyone can help??? On Mon, 12 Apr 2...

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)
Hi, Our hosting company is Yahoo! and we have a MySQL 4.1.6 database. phpMyAdmin 2.6.3 is installed and I can manipulate the db fine through that. However, when I try and connect through a PHP file using $db_hostname = "localhost"; $db_socket = ""; $mysql_host = $db_hostname; if (!empty($db_socket)) $mysql_host .= ":$db_socket"; $db_name = "mydb"; $db_user = "myuser"; $db_password = "mypass"; // Connect mysql_connect($mysql_host, $db_user, $db_password) or die("Can't connect to MySQL: '" . mysql_error() . "'"); I get the above error. How can I fix this? Thanks, - Dave laredotornado@zipmail.com wrote: > Hi, > > Our hosting company is Yahoo! and we have a MySQL 4.1.6 database. > phpMyAdmin 2.6.3 is installed and I can manipulate the db fine through > that. However, when I try and connect through a PHP file using > > $db_hostname = "localhost"; > $db_socket = ""; > > $mysql_host = $db_hostname; > if (!empty($db_socket)) > $mysql_host .= ":$db_socket"; > $db_name = "mydb"; > $db_user = "myuser"; > $db_password = "mypass"; > > // Connect > mysql_connect($mysql_host, $db_user, $db_password) or die("Can't > connect to MySQL: '" . mysql_error() . "'"); > > I get the above error. How can I fix this? > >...

Seen this message? Can't connect to local MySQL server through socket '/tmp/mysql.sock'
Seen this message? Can't connect to local MySQL server through socket '/tmp/mysql.sock' I got this trying to install DBI and DBD for mysql from CPAN. After fumbling, a comment by somebody said "Make /tmp world writable and set the sticky bit" OK so chmod uog+t /tmp (and I did +rwx too - was that wrong?) but no dice, so knowing that mysql has set up its socket in /var/lib/mysql/mysql.sock and finding no obvious way to change this default, I used a soft link in /tmp ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock and now everything works right. But, have I compr...

Can't connect to local MySQL server through socket '/tmp/mysql.sock' PDO exception
Hi Environment: some version of Slackware, Apache 2.2.x, PHP 5.1.5, MySQL 5.0.24. The issue: I'm using Zend Framework Zend_Db component (which uses PDO). We have 2 mysql socket related settings in php.ini: mysql.default_socket = /var/run/mysql/mysql.sock mysqli.default_socket = /var/run/mysql/mysql.sock On MySQL command prompt, query "SHOW VARIABLES LIKE '%socket%';" returns the variable "socket" with correct (desired) value "/var/run/mysql/mysql.sock". But still, the output of phpinfo() contains the following lines in mysql and mysqli sections, r...

Can't connect '/var/lib/mysql/mysql.sock' (13)
Hello All I'm new to Linux and am trying to learn to develop PHP and MySQL web applications but am stuck. I'm running Suse 10.0 and have installed Apache, PHP and MySQL from the DVD. Apache, and PHP are working and <?php phpinfo(); ?> produces the expected output. MySQL is also working and I've used knoda to create a sample database. I'm using this php to try to connect to MySQL $mysqluser = 'root'; $mysqlpasswd = 'mypassword123'; $mysqlhost = 'localhost'; $connID = mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd); However, when I try ...

DBI problem: Can't connect to MySQL server on 'localhost' (10061
I know this arises from time to time, and yes, I have tried everything mentioned in the MySQL reference manual I know the server (MySQL 5.1.50) is running. All of the following work perfectly: mysql -h localhost --port=33066 -u MyUID -pMyPassword merchants2 mysql -h 127.0.0.1 --port=33066 -u MyUID -pMyPassword merchants2 mysql -h 192.168.2.8 --port=33066 -u MyUID -pMyPassword merchants2 All the above connect and let me run any SQL statement. But the following scriptlet dies on the last statement with the error: DBI connect('database=merchants2;host=localhost','rejbyers',.....

[SOLARIS
We are facing problem in starting mysql [MySQL 3.23.58] in Solaris 8 platform and exception is thrown 'Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!'. I have tried using using either root or specific user. If I check MySQL logs by viewing /opt/mysql/data/<hostname>.err 040119 09:34:32 mysqld started Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040119 9:34:32 Aborting 040119 9:34:32 /opt/mysql/bin/mysqld: Shutdown Complete 040119 09:34:32 mysqld ended I've tried several times to install it, but still get the same error. Any clue on that problem ? Any help to solve this problem is really appreciated. Regards, Chithuu ..! Chithu wrote: > We are facing problem in starting mysql [MySQL 3.23.58] in Solaris 8 > platform and exception is thrown 'Fatal error: Can't change to run as > user 'mysql' ; Please check that the user exists!'. > > I have tried using using either root or specific user. > > If I check MySQL logs by viewing > /opt/mysql/data/<hostname>.err > > > 040119 09:34:32 mysqld started > Fatal error: Can't change to run as user 'mysql' ; Please check that > the > user exists! > 040119 9:34:32 Aborting > 040119 9:34:32 /opt/mysql/bin/mysqld: Shutdown Complete > 040119 09:34:32 mysqld ended &...

can't connect to mysql on 'local host', installing 5.0.19
I had to delete all old files and disable norton firewall to get the install to work. but I still get, after everything's applied, can't connect to mysql on 'local host' (10061) 10061 is a winsock error WSAECONNREFUSED. so the dialog box recommends to press the skip button "because you are probably doing an upgrade (shouldn't! I wasn't) and run the config wizard. so I did and that went OK. the service got installed, and can start and stop, but won't connect. probably the same error, but can't tell because no log details. I have seen this error messa...

can't restart mysql server, pid or mysql.sock error
I only use this server as a test server. It has been working and I don't r= emember changing anything out of the ordinary but now I can't login to phpm= yadmin and I can't stop the server. =20 Here are the command line tries: sh-3.2# /usr/local/mysql/support-files/mysql.server start Starting MySQL .. ERROR! Manager of pid-file quit without updating file. sh-3.2# service mysqld start service: failed to start the 'mysqld' service sh-3.2# /usr/local/mysql/bin/mysql stop ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tm= p/mysql.s...

Another 'can't get mysql server to run' post (6.0RC1)
Here is what is in place so far: 6.0RC1 mysql-4.15 I have installed mysql41-server from the ports Placed 'enable_mysql="YES"' and mysql_dbdir="/var/db/mysql" in rc.conf Run /usr/local/bin/mysql_install-db, creating a brand new mysql directory. I changed ownership of /var/db/mysql to root:wheel (and also root:mysql) I changed everything inside that to mysql:mysql. Nothing works. Not mysqld_safe --user=mysql --datadir=/var/db/mysql Not /usr/localetc/rc.d/mysql-server.sh start Not /usr/local/share/mysql/mysql.server start Nothing. /var/log/messages gives me this: 051030 10:26:32 mysqld started /usr/local/libexec/mysqld: File './auden-bin.000003' not found (Errcode: 13) 051030 10:26:32 [ERROR] Could not use auden-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 051030 10:26:32 [ERROR] Aborting 051030 10:26:32 [Note] /usr/local/libexec/mysqld: Shutdown complete 051030 10:26:32 mysqld ended That's right, .000003 is not in there (*.000002 is). Why would it be, it's a new installation. So what's the trick here? Ports have always been super, but as long as I can remember mysql from ports has been (for me) a pain in the ass; so much so that I have always chosen to run MySQL's binary package, which always works. I'd do that now but this is a 6.0 install and MyS...

MySQL: 'latin-1' codec can't encode character
Hi. I'm trying to store a text within a MySQL field (v 3.23.58) by using MySQLdb (v 1.2.1c3). The text is: "telephone..." (note the last character) And I get this error message: ----------- File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler raise errorclass, errorvalue UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2026' in position 288: ordinal not in range(256) ----------------------- Position 288 is the character I've mentioned. I suppose I must encode this caracter into a ri...

MySQL max_connect_errors 'concurrent' or 'accumulated'?
When I get Host 'host_name' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' error, I checked the manual and it is influenced by the variable 'max_connect_errors', but I don't know this connect_errors is meant 'concurrent' or 'accumulated'? I mean, will the host be blocked when it reach the max_connect_errors simultaneously or it will be blocked when all of its history connect errors has reached the max_connect_errors? Thank you. And I also want to know why and how these failed connecting occur? I can't fo...

Can't connect to MySQL server
Hi I am trying to get connect to mysql database . Facing Error: Can't connect to MySQL server on '64.95.73.14' (110) (Mysql::Error) Using Ruby: 1.8.6 mysql: 2.7 database machine ip: 64.95.73.14 Could someone provide any pointer?? Thanks Darshana -- Posted via http://www.ruby-forum.com/. [Note: parts of this message were removed to make it a legal post.] Hey did you check with the premissions of mysql. If you are a sudo user you must also give the username and password along with the connections. kranthi. On Tue, Jul 29, 2008 at 12:26 PM, Darshana Gangwal <d...

Can't connect to the MySQL-Server through PHP
Hello, I've got a problem connecting to the MySQL-Server with a PHP-script. The facts: OpenBSD 4.2 MySQL-Server 5.0 Default Apache Webserver PHP 5.2.3 The MySQL socket lies in /var/www/run/mysql/: # ls -la /var/www/run/mysql/ drwxrwxrwx 2 _mysql _mysql 512 Jan 25 11:39 . drwxr-xr-x 3 root daemon 512 Jan 23 20:01 .. srwxrwxrwx 1 _mysql _mysql 0 Jan 25 11:39 mysql.sock The MySQL-socket-path line in the php.ini: mysql.default_socket = /run/mysql/mysql.sock; Everytime I open the PHP-Script which tries to connect to a MySQL- database in my browser I get the s...

MyODBC can't connet to local MySQL server
I'm having a problem with what should be a straightforward LAN config. I have MySQL running on Mandriva 2006. I have MyODBC 3.51 installed on WinXP. The local IP for MySQL is 192.168.0.3. The local IP for WinXP is 192.168.0.1. I setup MyODBC as follows: Data Source Name: MyODBC Description: MySQL Server Server: 192.168.0.103 User: [valid_user] Password: [valid_pw] Database: [valid_db] The error message is [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '192.168.0.103' (10061) I have checked the docs, but nothing obvious was found. Can someone offer me a clue? ...

Mysql can connect, but PHP can't?
Hi, my first time posting on a newsgroup. anyway, let's cut to the chase. I'm trying to migrate mysql database form one server to another server. So I copied the data from /var/lib/mysql to the other one.. and use INSERT INTO from the old database to the new one..so the Top level 'mysql' database has all the correct users and password and priviledge. however, when one of the php website trying to load..it'll say Unable to login to the MySQL database 'tikiwiki' on 'localhost' as user 'user1' Go here to begin the installation process, if you haven&#...

mysql 5.0.9 in redhat 9.0 -- i can't include mysql.h header file in c++ coding
can u tell me how to include the mysql file ,mysql is installed but the mysql folders and header file is not present in the /var/lib/mysql or /usr/include/mysql any one can tell me how to install header file in redhat 9.0 , where the header file located for the mysql ...

I can't believe how many people don't realize how many of their questions are answered in the PHP/MySQL/Apache documentation!
'nuff said. Just venting... -- Jeffrey D. Silverman | jeffrey AT jhu DOT edu Johns Hopkins University | Baltimore, MD Website | http://www.wse.jhu.edu/newtnotes/ With total disregard for any kind of safety measures "Jeffrey Silverman" <jeffrey@jhu.edu> leapt forth and uttered: > 'nuff said. Just venting... first rule of cluebieism: Never read the manual. -- There is no signature..... Jochen Buennagel wrote: > I've found the same on numerous forums, and I attribute it to pure > lazyness: They think it is easier to ask someone t...

MySql 4.1.1 Password problem
Hello, Newbie here..... Searching and working this for a week now. We too are having the same problems. Using MySql 4.0.14 and there are "no problems" at all. However when we went to MySql 4.1.1 we cannot connect using clients (such as PhpMyAdmin or PhpAdsNew) if there is any password. Remove the password and 4.1.1 is fine. I have also tried to start the database using both bin/mysqld_safe & bin/mysqld_safe --old-passwords & with no luck We have added users via telnet.... ************************** INSERT INTO user VALUES ('localhost,'test','...

Lost connection to MySQL server at 'reading initial communication packet', error 111
Hi all, I installe Apache2, PHP5 e Mysql on a Debian distribution If I try to connect to the database with a simple php script, the following error occurs: Lost connection to MySQL server at 'reading initial communication packet', error 111 I edited the /etc/my.cnf file and I commented the line about bind_address. User and passwrod are correct because typing from console mysql -uroot I can access to mysql environment. The port 3306 is opened beacuse I haven't entries in iptable and because i configured my router opening just the port 3306 The server ip is 192.168.0.100, ...

my php can't connect the mysql
A question : why my php can't connect the mysql. my php version is 5.014 and my mysql version is also 5.0, but i run them on the windows xp system. who knows the real problem? I searched this at google,but I still haven't got the way to deal with my problem. On 16 Aug., 03:10, "zhenwe...@gmail.com" <zhenwe...@gmail.com> wrote: > A question : why my php can't connect the mysql. > > my php version is 5.014 and my mysql version is also 5.0, > but i run them on the windows xp system. > who knows the real problem? > > I searched this at google,...

Can't connect to a mySQL DB
Hi everyone I'm trying connecting to a mySQL DBm but I've some troubles. The code is <?php echo "Connecting ... "; $connection = mysql_connect("localhost", $usename, $password) or die ("KO: " . mysql_error()); echo "OK"; .... When I execute, the php page just writes: "Connecting ..." and then the execution stops, without printing anything else. The problem is not dipendent by the parameters, it happens the same also if I write wrong parameters. Can someone help me in order to fix the problem? Tanks in advance for your...

Can't connect to MySQL from remote
I have some problems with MySQL 3.23.52 on RedHat Linux 8.0. I can connect to mysql when I am on the same machine but I can't connect to it from another machine. Here is the error I get: > mysqladmin -u cedric -h gdvi02 version mysqladmin: connect to server at 'gdvi02' failed error: 'Lost connection to MySQL server during query' What's the problem ? C�dric Pillonel C=E9dric Pillonel wrote: >I have some problems with MySQL 3.23.52 on RedHat Linux 8.0. > >I can connect to mysql when I am on the same machine but I can't connect= to >it from another machine. Here is the error I get: > > =20 > >>mysqladmin -u cedric -h gdvi02 version >> =20 >> >mysqladmin: connect to server at 'gdvi02' failed >error: 'Lost connection to MySQL server during query' > >What's the problem ? > >C=E9dric Pillonel > > > > =20 > Are you sure it is set up to listen on the network? The default=20 configuration is often to listen only on Unix socket. Check the configration file for the skip-networking option. --=20 J. D. Addison email puff@theaddisons.demon.co.uk=20 C�ric Pillonel wrote: > I have some problems with MySQL 3.23.52 on RedHat Linux 8.0. > > I can connect to mysql when I am on the same machine but I can't connect > to it from another machine. Here is the error I get: > >> mysqladmin -u cedric -h gdvi02 version > mysqladmin: conn...

Web resources about - Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD - comp.databases.mysql

Resources last updated: 3/22/2016 6:34:01 AM