Re: Mysqld problem

[Phil Dobbin]

On 23/3/03 16:36, "Jeff Shapiro" <[EMAIL PROTECTED]> wrote:

> 
> It looks to me like you have a permissions problem with your
> directories. You need to make sure that the directory own for the
> mysql directory tree is your mysql user.

[...]

> I just checked your error code with:
> [~] [0] > perror 13
> Error code  13:  Permission denied
> 
> So it definitely looks like it's a permissions problem.
> 
> Try using this command in the Terminal program:
> 
> chown -R mysql /usr/local/mysql-3.23.51/

Hi, Jeff.

Right on the money! mysqld is now running happily and I can get into my
data. How the hell the permissions got screwed up like that, I've no idea
but now I know the error code, I'll know what to look for if it happens
again.

Many thanks,

Regards,

Phil.


> At 13:09 + 3/23/03, Phil Dobbin wrote:
>> I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X
>> 10.1.5 and have a startup script which confirms on boot that it has started
>> but doesn't.
>> 
>> I've tried starting manually from the CLI but no luck. I looked in
>> localhost.err and found:
>> 
>> 030323  9:48:21  /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write to
>> file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
>> 030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Can't find file:
>> './mysql/host.frm' (errno: 13)
>> 030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of
>> '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
>> 030323 09:48:22  mysqld ended
>> 
>> According to the O'Reilly `MySQL Reference Manual' it seems that the daemon
>> may have been damaged but offers no real clue as how to fix it.
>> 
>> One other very odd aspect is that on OS X you create a mysql user in Sys
>> Prefs and I noticed, upon reboot, that this user had disappeared from the
>> pref panel. I re-created but to no avail.
>> 
>> Any help at all on this would be gratefully appreciated.
>> 
>> Regards,
>> 
>> Phil.
>> 
>> 
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AW: AW: AW: Mysqld problem

[Phil Dobbin]

On 23/3/03 15:41, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:

> Hi Phil,
> 
> I guess I don't know the "best possible way" (is there realy one?). But
> let's see... Your OS is OS X? At the moment you are using 3.23.51, the
> actual Version is 3.23.56 I think ... well you could date your system up I
> guess (
> http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-3.23%2Fmy
> sql-3.23.56-apple-darwin6.4-powerpc.tar.gz&pick=mirror ) or you need to find
> your version of mysql ..

[...]

Thanks for that. You've made my mind up (I've been thinking for a few hours
now of upgrading to see if that would solve things). I use Marc Liyanage's
binary versions, so I guess I'll head over to his site.

Many thanks for all your help,

Regards,

Phil.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AW: AW: Mysqld problem

[Phil Dobbin]

On 23/3/03 15:27, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:

> Hi Phil,
> 
> ok, just to make sure your mysqld isn't damaged, what about replacing it
> with a new one (just binaries, not config and data)?

Sounds a good idea but I'm unsure how to go about it. Would you know the
best possible way?

Regards,

Phil.


> -Ursprungliche Nachricht-
> Von: Phil Dobbin [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 23. Marz 2003 16:21
> An: Stefan Siefert; MySQL
> Betreff: Re: AW: Mysqld problem
> 
> 
> On 23/3/03 13:31, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:
> 
>> Hi Phil,
>> 
>> first of all I don't think your mysqld is damaged. I would first check the
>> following:
>> 
>> - where does mysqld looks for its datadir?
>> - under which userid is mysqld supposed to run?
>> - under which userid does mysqld runs?
>> - does the user under which mysqld runs have write access to the datadir
>> directory?
>> - is the mysql database installed in the datadir directory?
> 
> Hi, Stefan.
> 
> All things mysql are in their correct place (this has only just happened and
> I haven't changed anything in any directory pertaining to mysql).
> 
> I basically cannot get mysqld to start in any shape or form, either from its
> system boot startup script or manually.
> 
> Regards,
> 
> Phil.
> 
> 
>> 
>> -Ursprungliche Nachricht-
>> Von: Phil Dobbin [mailto:[EMAIL PROTECTED]
>> Gesendet: Sonntag, 23. Marz 2003 14:09
>> An: MySQL
>> Betreff: Mysqld problem
>> 
>> 
>> I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X
>> 10.1.5 and have a startup script which confirms on boot that it has
> started
>> but doesn't.
>> 
>> I've tried starting manually from the CLI but no luck. I looked in
>> localhost.err and found:
>> 
>> 030323  9:48:21  /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write
> to
>> file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
>> 030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Can't find file:
>> './mysql/host.frm' (errno: 13)
>> 030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of
>> '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
>> 030323 09:48:22  mysqld ended
>> 
>> According to the O'Reilly `MySQL Reference Manual' it seems that the
> daemon
>> may have been damaged but offers no real clue as how to fix it.
>> 
>> One other very odd aspect is that on OS X you create a mysql user in Sys
>> Prefs and I noticed, upon reboot, that this user had disappeared from the
>> pref panel. I re-created but to no avail.
>> 
>> Any help at all on this would be gratefully appreciated.
>> 
>> Regards,
>> 
>> Phil.
>> 
>> 
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/[EMAIL PROTECTED]
>> 
>> 
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AW: Mysqld problem

[Phil Dobbin]

On 23/3/03 13:31, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:

> Hi Phil,
> 
> first of all I don't think your mysqld is damaged. I would first check the
> following:
> 
> - where does mysqld looks for its datadir?
> - under which userid is mysqld supposed to run?
> - under which userid does mysqld runs?
> - does the user under which mysqld runs have write access to the datadir
> directory?
> - is the mysql database installed in the datadir directory?

Hi, Stefan.

All things mysql are in their correct place (this has only just happened and
I haven't changed anything in any directory pertaining to mysql).

I basically cannot get mysqld to start in any shape or form, either from its
system boot startup script or manually.

Regards,

Phil.


> 
> -Ursprungliche Nachricht-
> Von: Phil Dobbin [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 23. Marz 2003 14:09
> An: MySQL
> Betreff: Mysqld problem
> 
> 
> I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X
> 10.1.5 and have a startup script which confirms on boot that it has started
> but doesn't.
> 
> I've tried starting manually from the CLI but no luck. I looked in
> localhost.err and found:
> 
> 030323  9:48:21  /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write to
> file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
> 030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of
> '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
> 030323 09:48:22  mysqld ended
> 
> According to the O'Reilly `MySQL Reference Manual' it seems that the daemon
> may have been damaged but offers no real clue as how to fix it.
> 
> One other very odd aspect is that on OS X you create a mysql user in Sys
> Prefs and I noticed, upon reboot, that this user had disappeared from the
> pref panel. I re-created but to no avail.
> 
> Any help at all on this would be gratefully appreciated.
> 
> Regards,
> 
> Phil.
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysqld problem

[Phil Dobbin]

I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X
10.1.5 and have a startup script which confirms on boot that it has started
but doesn't.

I've tried starting manually from the CLI but no luck. I looked in
localhost.err and found:

030323  9:48:21  /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write to
file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of
'/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
030323 09:48:22  mysqld ended

According to the O'Reilly `MySQL Reference Manual' it seems that the daemon
may have been damaged but offers no real clue as how to fix it.

One other very odd aspect is that on OS X you create a mysql user in Sys
Prefs and I noticed, upon reboot, that this user had disappeared from the
pref panel. I re-created but to no avail.

Any help at all on this would be gratefully appreciated.

Regards,

Phil.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql on OS X >>>PROBLEM!

[Phil Dobbin]

On 12/9/02 13:03, "philipp ringli" <[EMAIL PROTECTED]> wrote:

> hi all,
> 
> i am running OS X 10.2 and
> this version of mysql:
> 
> mysql> status
> --
> ./bin/mysql  Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)

[...]

> my problem is the following:
> 
> let's say i want to add the following user (just as a test):
> 
> mysql> grant all
>   -> on *
>   -> to test
>   -> with grant option;
> 
> i do that and then i do a
> mysql> use mysql;
> mysql> SELECT * FROM user;
> 
> the thing is, that all the permissions are still set to 'N'!! it won't
> accept the grant arguments. also after a mysqladmin reload!
> i also have phpMyAdmin 2.3.0 installed and if i change the user's
> permissions in there, it accepts them. then also the terminal will list them
> properly.
> 
> why is this happening?

Just a guess (I haven't installed it yet) but I'm guessing it's probably a
10.2 problem.

HTH,

Regards,

Phil.


-
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: Understanding relational database setup/construction

[Phil Dobbin]

On 22/6/02 at 17:05, [EMAIL PROTECTED] (Timothy J. Luoma) wrote:
 
> I've looked through Google and the MySQL website without luck.
> 
> I'm looking to find a place which discusses the theory of how one 
> should
> create a database, how to organize the information, etc.
> 
> There's got to be a good site out there, but I'm obviously plugging in 
> the
> wrong search terms or something.

Try the second edition of O'Reilly books' "Managing and Using MySQL" ISBN:0596002114.

That'll get you started.

Regards,

Phil.

-
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: MySQL port # ?

[Phil Dobbin]

On 14/6/02 at 16:44, [EMAIL PROTECTED] (Laura Findley) wrote:

> Does anyone know how to determine what port MySQL is using? 
> 
> I need to know the port so that I can use it in a JDBC connection URL.
> 
> Any suggestions on how to get this info?

I believe `\s' is the command you need (without the quotes or backticks of course ;-)

Regards,

Phil.

-
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: Compilation Error on Mac OS X

[Phil Dobbin]

On 9/6/02 at 02:32, [EMAIL PROTECTED] (Tom Harris) wrote:

> Dear All,
> 
> I am new to the mailing list so I apologise in advance if I am posting 
> to
> the wrong place. Please direct me if I am wrong.
> 
> With Mac OS 10.1.5:
> 
> Configuring like this was okay:
[...]
> Then issuing "make" went fine and compilation proceeded for a long 
> while and
> then:
[...]
> sql_udf.cc:57: dlfcn.h: No such file or directory
> make[3]: *** [sql_udf.o] Error 1
> make[2]: *** [all-recursive] Error 1
> make[1]: *** [all-recursive] Error 1
> make: *** [all-recursive-am] Error 2
> 
> Further reading on various places on the internet seems to indicate 
> that
> this header file (dlfcn.h) is not included with the Apple Developer 
> Kit
[...]
> Is it necessary for me to go through the process of installing the
> 'dlcompat' package and if so, I wonder why that is not mentioned in 
> any of
> the material about compilation on OS X.
> 
> Can anyone answer my rather convoluted question? Thanks

Not really but have you considered using Marc Liyanage's binary installation of MySQL 
(in fact, I believe he also has a source install as well)?

You can find it at:



Many, many Mac OS X users (including myself) have used this and found it excellent and 
painless in the installation and use of.

Hope this helps,

Regards,

Phil.

-
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: msql.h

[Phil Dobbin]

On 28/5/02 at 12:59, [EMAIL PROTECTED] (Amy Zediak) wrote:

> Where is msql.h located?

On which OS?

Regards,

Phil.

-
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: Problem starting server

[Phil Dobbin]

On 27/5/02 at 16:53, [EMAIL PROTECTED] (Matt Hargraves) wrote:

> OK, that helps a lot.
> 
> There is no '/usr/local/mysql directory'  Any chance that this is 
> different
> in RedHat?
> 
> There is very little in the rc.local file and nothing having to do 
> with
> mysql.

Try etc/rc.d/init.d

That's where the mysql start-up script is installed in RH.

And that's _all_ I know about RH (I'm on Mac OS X).

Regards,

Phil.


> - Original Message -
> From: "Phil Dobbin" <[EMAIL PROTECTED]>
> To: "Matt Hargraves" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, May 27, 2002 3:56 PM
> Subject: Re: Fw: Problem starting server
> 
> 
> >
> > Not really. Try looking in /usr/local/mysql/bin where on most *nixs 
> the
> start-up script resides (safe_mysqld).
> >
> > To modify it there is a file called /etc/rc.local (or rc.local). See 
> if
> this has been altered. There is also the error log called hostname.err 
> which
> will give you (and anybody else trying to help) a more verbose message 
> than
> the one you've posted.
> >
> > Regards,
> >
> > Phil.
> >
> > p.s. I'm getting a "Sorry. Your message could not be delivered to:
> > w3d3demo (Mailbox or Conference is full.)" when posting to your 
> address
> (in the To: Field).
> >
> >
> > > - Original Message -
> > > From: "Phil Dobbin" <[EMAIL PROTECTED]>
> > > To: "Matt Hargraves" <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > Sent: Monday, May 27, 2002 1:32 PM
> > > Subject: Re: Fw: Problem starting server
> > >
> > >
> > > > On 27/5/02 at 12:47, [EMAIL PROTECTED] 
> (Matt
> > > Hargraves) wrote:
> > > >
> > > > > I keep getting the following error:
> > > > >
> > > > > error: 'Can't connect to MySQL server through the socket
> > > > > '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is 
> running
> > > and
> > > > > that the
> > > > > socket: '/var/lib/mysql/mysql.sock' exists!
> > > >
> > > > Try the manual:
> > > >
> > > > <http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html>
> > > >
> > > > HTH,
> > > >
> > > > Regards,
> > > >
> > > > Phil.
> > > >
> > > >
> > > 
> -
> > > > 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]
> > > com>
> > > > 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
> > >
> >
> > 
> -
> > 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]
> com>
> > 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

Re: Fw: Problem starting server

[Phil Dobbin]

On 27/5/02 at 14:39, [EMAIL PROTECTED] (Matt Hargraves) wrote:

> Been there, done that.  Didn't change a thing.
> 
> Guess I should have changed the e-mail before resending it, but I'm 
> not
> really sure what the problem is.  The server won't start for more than 
> a
> tenth of a second.  Here's what happens when I try to start mysqld:
> 
> [root@server mysql]# safe_mysqld
> Starting mysql daemon with databases from /var/lib/mysql
> 020527 02:26:27   mysql ended
> 
> Both statements ('Starting...' and '0205...') pop up within a tenth of 
> a
> second of each-other and when I check processes, there is nothing that
> starts with 'my' running.
> 
> Does that help?


Not really. Try looking in /usr/local/mysql/bin where on most *nixs the start-up 
script resides (safe_mysqld).

To modify it there is a file called /etc/rc.local (or rc.local). See if this has been 
altered. There is also the error log called hostname.err which will give you (and 
anybody else trying to help) a more verbose message than the one you've posted.

Regards,

Phil.

p.s. I'm getting a "Sorry. Your message could not be delivered to:
w3d3demo (Mailbox or Conference is full.)" when posting to your address (in the To: 
Field).


> - Original Message -
> From: "Phil Dobbin" <[EMAIL PROTECTED]>
> To: "Matt Hargraves" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, May 27, 2002 1:32 PM
> Subject: Re: Fw: Problem starting server
> 
> 
> > On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt
> Hargraves) wrote:
> >
> > > I keep getting the following error:
> > >
> > > error: 'Can't connect to MySQL server through the socket
> > > '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running 
> and
> > > that the
> > > socket: '/var/lib/mysql/mysql.sock' exists!
> >
> > Try the manual:
> >
> > <http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html>
> >
> > HTH,
> >
> > Regards,
> >
> > Phil.
> >
> > 
> -
> > 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]
> com>
> > 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
> 

-
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: Problem starting server

[Phil Dobbin]

On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt Hargraves) wrote:

> I keep getting the following error:
> 
> error: 'Can't connect to MySQL server through the socket
> '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and 
> that the
> socket: '/var/lib/mysql/mysql.sock' exists!

Try the manual:



HTH,

Regards,

Phil.

-
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: MySQL on Mac OS X

[Phil Dobbin]

On 12/5/02 at 18:40, [EMAIL PROTECTED] (Phil Dobbin) wrote:

> I got finally got it started by doing:
> 
> su mysql
> password xx
> mysql% cd /usr/local/mysql
> mysql% ./bin/safe_mysqld --user=mysql
> 
> but now I get 1045 error messages when I try to access mysql whether 
> as me or root:
> 
> [localhost:~] phil% mysqladmin reload
> .../bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'phil@localhost' (Using password: 
> YES)'
> [localhost:~] phil% mysqladmin -u root -p create database_name
> Enter password: 
> .../bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: 
> YES)'
> [localhost:~] phil% 

Well, I finally got in but now I get a 1044 error:

[localhost:~] phil% mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 3.23.49-entropy.ch

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database CONTACT;
ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT'
mysql> 

Any thoughts on this one? Basically I need to access the user tables but it will not 
let me any further than here.

Regards,

Phil.

-
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: MySQL on Mac OS X

[Phil Dobbin]

On 12/5/02 at 12:18, [EMAIL PROTECTED] (Paul DuBois) wrote:

> At 13:36 +0100 5/12/02, Phil Dobbin wrote:
[...]
> >20512 00:13:18  mysqld restarted
> >rm: /usr/local/mysql/data/localhost.pid: Permission denied
> >../bin/safe_mysqld: permission denied: 
> >/usr/local/mysql/data/localhost.err [235]
> >tee: /usr/local/mysql/data/localhost.err: Permission denied
> >
> >ad infinitum (I eventually have to "sudo kill -9 PID" to stop it).
> >
> >I've added a ~/.my.cnf file (per instructions in the MySQL manaul) 
> >but that makes no difference. Could someone advise me on which file 
> >I have to edit to enable start up and use of MySQL (huge_cnf?)?
> >
> >Also, I'm using Marc Liyange's Entropy installation. Has anybody 
> >used his uninstall script and, if so, how safe was it (it looks like 
> >I may have to uninstall and start again)?
> 
> Doesn't look like a configuration file problem, looks like a file 
> ownership
> problem.  The server needs to be able to access its files.  Try (as 
> root):
> 
> # cd /usr/local
> # chown -R mysql mysql
> 
> My guess is that the mysql hierarchy is owned by root, and that when 
> you
> specify --user=mysql to run the server, it can't write to root-owned
> directories.

I got finally got it started by doing:

su mysql
password xx
mysql% cd /usr/local/mysql
mysql% ./bin/safe_mysqld --user=mysql

but now I get 1045 error messages when I try to access mysql whether as me or root:

[localhost:~] phil% mysqladmin reload
../bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'phil@localhost' (Using password: YES)'
[localhost:~] phil% mysqladmin -u root -p create database_name
Enter password: 
../bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
[localhost:~] phil% 

This is just a small selection of the error messages I'm getting. I've added a 
~/.my.cnf file but to no avail and studied the appropriate pages of the manual but I 
cannot connect to mysql.

Any further help appreciated (the original lines you suggested I used when I 
installed).

Regards,

Phil.

-
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

MySQL on Mac OS X

[Phil Dobbin]

I'm still trying to get MySQL running on Mac OS X and previously after installation 
when MySQL was running, I was getting 1045/6 errors and now, after a re-boot, MySQL is 
not running (I didn't add the start-up script because of the constant permissions 
errors I was getting).

When I try to enter mysql I get:

[localhost:~] phil% mysql -p
Enter password: 
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Also when I try to start up (using ./bin/safe_mysqld --user=mysql & ) I get:

20512 00:13:18  mysqld restarted
rm: /usr/local/mysql/data/localhost.pid: Permission denied
../bin/safe_mysqld: permission denied: /usr/local/mysql/data/localhost.err [235]
tee: /usr/local/mysql/data/localhost.err: Permission denied

ad infinitum (I eventually have to "sudo kill -9 PID" to stop it).

I've added a ~/.my.cnf file (per instructions in the MySQL manaul) but that makes no 
difference. Could someone advise me on which file I have to edit to enable start up 
and use of MySQL (huge_cnf?)?

Also, I'm using Marc Liyange's Entropy installation. Has anybody used his uninstall 
script and, if so, how safe was it (it looks like I may have to uninstall and start 
again)?

Regards,

Phil.


-
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: MySQL on Mac OS X

[Phil Dobbin]

On 6/5/02 at 19:53, [EMAIL PROTECTED] (Sven Bentlage) wrote:

> on my box the following helped:
> 
> (su to root)
> chown -R mysql /usr/local/mysql/var  (check if this is the path to 
> your 
> mysql var )
> (exit root)
> 
> that should do it.
> also check in the user and host table if a connection from localhost 
> is 
> allowed for the specific user..

Having looked, I have no /usr/local/mysql/var. The installation instructions (from 
Marc Liyanage's excellent website) were as follows (in part):

"sudo chown -R mysql /usr/local/mysql/*"

followed by: "sudo ./bin/safe_mysqld --user=mysql &"

Also, how do I check the user/host table?

Thanks for your help,

Regards,

Phil.


> On Monday, May 6, 2002, at 07:42 PM, Phil Dobbin wrote:
> 
> > Hi.
> >
> > I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation 
> > went fine (into /usr/local/) but now I'm having what I believe is a 
> > common permission problem. When trying to add a database I get the 
> > following error:
> >
> > [localhost:~] phil% mysql
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql> create database CONTACT;
> > ERROR 1044: Access denied for user: '@localhost' to database 
> 'CONTACT'
> > mysql>
> >
> > I couldn't find anything in the archives so I wondered, could 
> somebody 
> > let me know the workaround I need to do on the permissions to get me 
> > started?
> >
> > Any help appreciated.
> >
> > Regards,
> >
> > Phil.
> >
> > 
> -
> > 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

MySQL on Mac OS X

[Phil Dobbin]

Hi.

I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into 
/usr/local/) but now I'm having what I believe is a common permission problem. When 
trying to add a database I get the following error:

[localhost:~] phil% mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database CONTACT;
ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT'
mysql>

I couldn't find anything in the archives so I wondered, could somebody let me know the 
workaround I need to do on the permissions to get me started?

Any help appreciated.

Regards,

Phil.

-
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