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]
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: AW: Mysqld problem
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: AW: AW: Mysqld problem
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.gzpick=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: Mysqld problem
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: mysql on OS X PROBLEM!
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
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 # ?
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
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: http://www.entropy.ch.com/ 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
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
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] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: Problem starting server
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
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
MySQL on Mac OS X
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
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
Re: MySQL on Mac OS X
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
MySQL on Mac OS X
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
Re: MySQL on Mac OS X
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 mysql-unsubscribe- [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
