probably a permissions problem that I cannot figure out.
mySQL-5.1.34-osx10.4-powerpc-64bit Not sure how this happened, but mySql will not start anymore, either from the command line or the system pref control panel. here's a startup sample: [I have blocked out the password] Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/bin/ mysqld_safe --user=root --password= /usr/local/mysql/bin/mysqld_safe: line 209: /usr/bin/grep: cannot execute binary file 100113 16:21:07 mysqld_safe Logging to '/usr/local/mysql/data/Power- Mac-G5.local.err'. 100113 16:21:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 100113 16:21:08 mysqld_safe mysqld from pid file /usr/local/mysql/ data/Power-Mac-G5.local.pid ended Power-Mac-G5:/usr/local/mysql chriselhardt$ pwd /usr/local/mysql and another one: Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/ support-files/mysql.server start Starting MySQL.. ERROR! Manager of pid-file quit without updating file. where are the config files supposed to be? ~Users/ chriselhardt/.my.cnf has only a single line, [mySQL] and I'm pretty sure there used to be more in there than that. Thanks for any assistance. In the space of one hundred and seventy-six years the Mississippi has shortened itself two hundred and forty-two miles. Therefore ... in the Old Silurian Period the Mississippi River was upward of one million three hundred thousand miles long ... seven hundred and forty-two years from now the Mississippi will be only a mile and three-quarters long. ... There is something fascinating about science. One gets such wholesale returns of conjecture out of such a trifling investment of fact. M. Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: probably a permissions problem that I cannot figure out.
can you give us the error , it can be found on the file /usr/local/mysql/data/Power-Mac-G5.local.err Thanks Anand On Thu, Jan 14, 2010 at 9:49 AM, Chris Elhardt celha...@mac.com wrote: mySQL-5.1.34-osx10.4-powerpc-64bit Not sure how this happened, but mySql will not start anymore, either from the command line or the system pref control panel. here's a startup sample: [I have blocked out the password] Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/bin/mysqld_safe --user=root --password= /usr/local/mysql/bin/mysqld_safe: line 209: /usr/bin/grep: cannot execute binary file 100113 16:21:07 mysqld_safe Logging to '/usr/local/mysql/data/Power-Mac-G5.local.err'. 100113 16:21:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 100113 16:21:08 mysqld_safe mysqld from pid file /usr/local/mysql/data/Power-Mac-G5.local.pid ended Power-Mac-G5:/usr/local/mysql chriselhardt$ pwd /usr/local/mysql and another one: Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL.. ERROR! Manager of pid-file quit without updating file. where are the config files supposed to be? ~Users/chriselhardt/.my.cnf has only a single line, [mySQL] and I'm pretty sure there used to be more in there than that. Thanks for any assistance. In the space of one hundred and seventy-six years the Mississippi has shortened itself two hundred and forty-two miles. Therefore ... in the Old Silurian Period the Mississippi River was upward of one million three hundred thousand miles long ... seven hundred and forty-two years from now the Mississippi will be only a mile and three-quarters long. ... There is something fascinating about science. One gets such wholesale returns of conjecture out of such a trifling investment of fact. M. Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=anand@gmail.com
Is this a permissions problem?
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [MySQL][ODBC 3.51 Driver]Access denied for user: '@localhost' to database 'client_db1' I am having trouble getting any MySQL site to work on my local PC, but they work fine remotely. I have just changed PC and now have IIS whereas before I used to have Personal Web Server. I have just managed to stop this happening with any microsoft access database site by changing permissions, but I am not having the same kind of result with the MySQL sites. Do I need to change permissions for the MySQL databases? If so, up on which folder do I change permissions. My websites are located in C:\inetpub\wwwroot, and MySQL is located at C:\mysql. The location of these folders didn't have any adverse effect with personal web server, does it with IIS? Mat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is this a permissions problem?
Matthew Stuart [EMAIL PROTECTED] wrote on 08/25/2005 03:26:51 PM: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [MySQL][ODBC 3.51 Driver]Access denied for user: '@localhost' to database 'client_db1' I am having trouble getting any MySQL site to work on my local PC, but they work fine remotely. I have just changed PC and now have IIS whereas before I used to have Personal Web Server. I have just managed to stop this happening with any microsoft access database site by changing permissions, but I am not having the same kind of result with the MySQL sites. Do I need to change permissions for the MySQL databases? If so, up on which folder do I change permissions. My websites are located in C:\inetpub\wwwroot, and MySQL is located at C:\mysql. The location of these folders didn't have any adverse effect with personal web server, does it with IIS? Mat Yes it is a permissions problem but not a _folder_ permissions problem. You error message tells me that you are attempting to authenticate with the mysql server as the mysql user anybody. The anybody account can be identified by the _lack_ of a name before the @ symbol. There are two things you need to check. A) there is a MySQL user with MySQL permissions to do whatever it is you want to do in MySQL. b) When you attempt to connect, you attempt to connect as that user. Check out the following reading for more details: http://dev.mysql.com/doc/mysql/en/user-account-management.html http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.html http://dev.mysql.com/doc/mysql/en/connecting.html http://dev.mysql.com/doc/mysql/en/access-denied.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Permissions problem with MySQL 4.1.3 | Update: Same with 5.0.1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I also tried the 5.0.1 MAX binaries looking for a solution to my previously posted problem of permissions (see at the bottom of the message for the previous post). According to the hostname.err file: 040810 13:31:44 mysqld started 040810 13:31:44 bdb: /usr/local/mysql5/data: Permission denied 040810 13:31:44 bdb: /usr/local/mysql5/data/log.01: Permission denied 040810 13:31:44 bdb: PANIC: Permission denied 040810 13:31:44 bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 040810 13:31:44 bdb: fatal region error detected; run recovery 040810 13:31:44 bdb: /usr/local/mysql5/data: Permission denied 040810 13:31:44 InnoDB: Started; log sequence number 0 43634 040810 13:31:44 Can't init databases 040810 13:31:44 Aborting 040810 13:31:44 InnoDB: Starting shutdown... 040810 13:31:46 InnoDB: Shutdown completed; log sequence number 0 43634 040810 13:31:46 /usr/local/mysql5/bin/mysqld: Shutdown complete 040810 13:31:46 mysqld ended A complete archived plaintext strace logfile can be found here: http://www.lwo-lab.net/log.mysql-list.01.gz It was generated using: # strace -v -s 512 -o log -f -v -t ./mysqld --user=mysql Before suggesting any chmod/chown, please take a look at this: tearspath www # ls -l -h /usr/local/mysql5/data/ total 19M -rw-rw 1 mysql mysql 4.0M Aug 10 14:25 ib_logfile0 -rw-rw 1 mysql mysql 4.0M Aug 9 14:36 ib_logfile1 -rw-rw 1 mysql mysql 10M Aug 10 14:25 ibdata1 drwxr-x--- 2 mysql mysql 4.0K Aug 9 14:27 mysql -rw-rw 1 mysql root 6.1K Aug 10 13:31 tearspath.err drwxr-x--- 2 mysql mysql 4.0K Jul 27 20:53 test I'd like to add that mysqld is properly running as mysql:mysql according to the strace log: 12299 14:25:07 setgid32(506)= 0 12299 14:25:07 setuid32(1006) = 0 (506 and 1006 are the respective GID and UID for mysql and mysql) Any help will be really appreciated, I'm on this for a month now. Thanks in advance. Elie `woe` BLETON Elie `woe` BLETON wrote: | Hello, | | I'd like to ask for some help on a problem which have prevented my mysql | server to run since I updated it from 4.0 to 4.1 | Anyway, even if in the idea it's an update, in the facts it's a fresh | install, from sources. | Sources were configure'd with ./configure --prefix=/usr/local/mysql. | | After doing everything I could find on google, manual, mailing lists and | stuff, I still have basicly the same problems : | | (a) Running mysql_install_db --user=mysql /dev/null prints a lot of | errors, most of them are Errcode: 13 (Permission denied), and resulting | Table 'xxx.yyy' doesn't exist messages. See Annex A for detailed output. | | (b) Running libexec/mysqld --console --user=mysql prints : | InnoDB: Operating system error number 13 in a file operation. | InnoDB: The error means mysqld does not have the access rights to | InnoDB: the directory. | InnoDB: File name /usr/local/mysql/var/ibdata1 | InnoDB: File operation call: 'create'. | InnoDB: Cannot continue operation. | | Running both of these programs as root works fine, but I don't really | want mysql to run as root, even if it's just for testing purposes. | | There are some points which seems really strange to me. First point is | that mysql_install_db is able to create mysql and test directories | in var without problem. | Nothing changes if I chown -R mysql:mysql /usr/local/mysql/var | Nothing changes if I chown -R mysql:mysql /usr/local/mysql | Nothing changes if I chmod -R 777 /usr/local/mysql | Nothing changes if these these elements are made altogether. | | The other strange point is that if the var directory isn't owned by | mysql user, InnoDB complaints about not beeing able to create | innodb.status. in var. Once var is owned by mysql, it can create the | file without problem. | I can't understand why it cannot create ibdata1 if it can create the | other one. | | I've also tried to install_db as root, then run mysqld as root for one | time in order to get inno files created properly. Switching back to | mysqld --user=mysql isn't possible anyway. | | I'm open to any suggestion or help, and available to provide any further | information as needed. Thanks in advance for your time. | | Elie `woe` BLETON | | APPENDIX A | Output of /usr/local/mysql/bin/mysql_install_db --user=mysql | | ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' | (Errcode: 13) | ERROR: 1146 Table 'mysql.db' doesn't exist | ERROR: 1146 Table 'mysql.db' doesn't exist | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/host.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/user.MYI' (Errcode: 13)
Permissions problem with MySQL 4.1.3
Hello, I'd like to ask for some help on a problem which have prevented my mysql server to run since I updated it from 4.0 to 4.1 Anyway, even if in the idea it's an update, in the facts it's a fresh install, from sources. Sources were configure'd with ./configure --prefix=/usr/local/mysql. After doing everything I could find on google, manual, mailing lists and stuff, I still have basicly the same problems : (a) Running mysql_install_db --user=mysql /dev/null prints a lot of errors, most of them are Errcode: 13 (Permission denied), and resulting Table 'xxx.yyy' doesn't exist messages. See Annex A for detailed output. (b) Running libexec/mysqld --console --user=mysql prints : InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name /usr/local/mysql/var/ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. Running both of these programs as root works fine, but I don't really want mysql to run as root, even if it's just for testing purposes. There are some points which seems really strange to me. First point is that mysql_install_db is able to create mysql and test directories in var without problem. Nothing changes if I chown -R mysql:mysql /usr/local/mysql/var Nothing changes if I chown -R mysql:mysql /usr/local/mysql Nothing changes if I chmod -R 777 /usr/local/mysql Nothing changes if these these elements are made altogether. The other strange point is that if the var directory isn't owned by mysql user, InnoDB complaints about not beeing able to create innodb.status. in var. Once var is owned by mysql, it can create the file without problem. I can't understand why it cannot create ibdata1 if it can create the other one. I've also tried to install_db as root, then run mysqld as root for one time in order to get inno files created properly. Switching back to mysqld --user=mysql isn't possible anyway. I'm open to any suggestion or help, and available to provide any further information as needed. Thanks in advance for your time. Elie `woe` BLETON APPENDIX A Output of /usr/local/mysql/bin/mysql_install_db --user=mysql ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' (Errcode: 13) ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 1146 Table 'mysql.db' doesn't exist ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/host.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/user.MYI' (Errcode: 13) ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1146 Table 'mysql.user' doesn't exist ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/func.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/tables_priv.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/columns_priv.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/help_topic.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/help_category.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/help_relation.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/help_keyword.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/time_zone_name.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/time_zone.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/time_zone_transition.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/time_zone_transition_type.MYI' (Errcode: 13) ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/time_zone_leap_second.MYI' (Errcode: 13) ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_category' doesn't exist ERROR: 1146 Table 'mysql.help_keyword' doesn't exist ERROR: 1146 Table 'mysql.help_relation' doesn't exist ERROR: 1146 Table 'mysql.help_category' doesn't exist ERROR: 1146 Table 'mysql.help_category' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table 'mysql.help_topic' doesn't exist ERROR: 1146 Table
Re: file permissions problem on ALTER TABLE
Can the MySQL AB folks please tell me whether this bug really exists in 3.23.54a? And, if so, can we look forward to 3.23.54b soonish? I am not ready yet for the 4.x series, as I generally frown upon running such a major engine for my server in gamma/beta software. But a shiny new 3.23 version would just do the trick. :) - Mark System Administrator Asarian-host.org --- If you were supposed to understand it, we wouldn't call it code. - FedEx - Original Message - From: Manuzhai [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 11, 2003 12:31 AM Subject: Re: file permissions problem on ALTER TABLE Hmm, okay, but isn't the 3.23 supposed to be stable and thus more bugless than a gamma like 4.0.7? And also, I was wondering when 4 is going to be released as stable. Looking over the changelogs, it shouldn't be too long, right? Zak: thanks for the advice. I got real pissed off about it, since it seems like a real bug. :) But I guess it helps pretty good. Regards, Dirkjan - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Dirkjan Ochtman [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 10, 2003 11:45 PM Subject: Re: file permissions problem on ALTER TABLE Dirkjan, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem, neither on Win98, Win2K, nor Linux. I did have problems like the ones you describe with 4.0.1, 4.0.3 and 4.0.4 under Win98 and Win2K. Using 4.0.7 now und Win98 and Win2K, the ALTER TABLE problems have gone. Reporting this problem to the list, I heard strange advices like switch lower_case_table_names to 0. I believe it's a MySQL on Win bug with the 4.0.x versions mentioned above, and it might also affect 3.23 version after 3.23.49. My advice is: Update, MySQL 4.0.7 is real funky :) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Dirkjan Ochtman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 7:40 PM Subject: Bug: file permissions problem on ALTER TABLE Hi there, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. I kept encountering this problem (trying to go from VARCHAR(6) to CHAR(6) for an index field), but it would only work after I restarted the mysqld-max-nt. Immediately after restarting the server, it worked, but then after a few minutes I tried to ALTER another field in the table, and it had the same problem. So I restarted the server again, it went through, but the problem persisted. I checked the file permissions, but everyone has full control to the files. The table now looks like this: CREATE TABLE postcodes ( id mediumint(8) unsigned NOT NULL auto_increment, postcode char(6) NOT NULL default '', plaats smallint(5) unsigned NOT NULL default '0', straat mediumint(8) unsigned NOT NULL default '0', low mediumint(5) unsigned NOT NULL default '0', high mediumint(5) unsigned NOT NULL default '0', parity enum('0','1','2') NOT NULL default '2', PRIMARY KEY (id), KEY postcode (postcode) ) TYPE=MyISAM; It has 570,441 rows. Is this a bug in MySQL, or am I doing something wrong? I was using phpMyAdmin to do the changes, but I don't think that should make any difference. - 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: file permissions problem on ALTER TABLE
Hi there, I still have problems with this when using MySQL 4.0.8. When I try to DROP a DATABASE, it will go through and delete all the tables, except the last two, apparently because it can't delete the table.myi file. When I restart the server, I can DROP one of the tables, then I get the error again for the other table, so then I restart the server again and I can DROP the last table. The problem also persists on ALTERing TABLEs. Regards, Dirkjan Dirkjan, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem, neither on Win98, Win2K, nor Linux. I did have problems like the ones you describe with 4.0.1, 4.0.3 and 4.0.4 under Win98 and Win2K. Using 4.0.7 now und Win98 and Win2K, the ALTER TABLE problems have gone. Reporting this problem to the list, I heard strange advices like switch lower_case_table_names to 0. I believe it's a MySQL on Win bug with the 4.0.x versions mentioned above, and it might also affect 3.23 version after 3.23.49. My advice is: Update, MySQL 4.0.7 is real funky :) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 Hi there, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. I kept encountering this problem (trying to go from VARCHAR(6) to CHAR(6) for an index field), but it would only work after I restarted the mysqld-max-nt. Immediately after restarting the server, it worked, but then after a few minutes I tried to ALTER another field in the table, and it had the same problem. So I restarted the server again, it went through, but the problem persisted. I checked the file permissions, but everyone has full control to the files. - 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: file permissions problem on ALTER TABLE
At 10:17 11/01/2003 +0100, Dirkjan Ochtman wrote: Hi, cut server, I can DROP one of the tables, then I get the error again for the other table, so then I restart the server again and I can DROP the last table. The problem also persists on ALTERing TABLEs. cut Please if possible for you send me a test case about the above issue and the contents of the my.cnf/my.ini file. Thanks. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug: file permissions problem on ALTER TABLE
Hi there, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. I kept encountering this problem (trying to go from VARCHAR(6) to CHAR(6) for an index field), but it would only work after I restarted the mysqld-max-nt. Immediately after restarting the server, it worked, but then after a few minutes I tried to ALTER another field in the table, and it had the same problem. So I restarted the server again, it went through, but the problem persisted. I checked the file permissions, but everyone has full control to the files. The table now looks like this: CREATE TABLE postcodes ( id mediumint(8) unsigned NOT NULL auto_increment, postcode char(6) NOT NULL default '', plaats smallint(5) unsigned NOT NULL default '0', straat mediumint(8) unsigned NOT NULL default '0', low mediumint(5) unsigned NOT NULL default '0', high mediumint(5) unsigned NOT NULL default '0', parity enum('0','1','2') NOT NULL default '2', PRIMARY KEY (id), KEY postcode (postcode) ) TYPE=MyISAM; It has 570,441 rows. Is this a bug in MySQL, or am I doing something wrong? I was using phpMyAdmin to do the changes, but I don't think that should make any difference. Regards, Dirkjan Ochtman P.S. I really dislike the spam/off-topic bot at [EMAIL PROTECTED] It doesn't want this email, and that gives me a kind of we-don't-want-help-even-if you-really-try-to-describe-the-problem kind of feeling. - 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: file permissions problem on ALTER TABLE
Dirkjan, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem, neither on Win98, Win2K, nor Linux. I did have problems like the ones you describe with 4.0.1, 4.0.3 and 4.0.4 under Win98 and Win2K. Using 4.0.7 now und Win98 and Win2K, the ALTER TABLE problems have gone. Reporting this problem to the list, I heard strange advices like switch lower_case_table_names to 0. I believe it's a MySQL on Win bug with the 4.0.x versions mentioned above, and it might also affect 3.23 version after 3.23.49. My advice is: Update, MySQL 4.0.7 is real funky :) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Dirkjan Ochtman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 7:40 PM Subject: Bug: file permissions problem on ALTER TABLE Hi there, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. I kept encountering this problem (trying to go from VARCHAR(6) to CHAR(6) for an index field), but it would only work after I restarted the mysqld-max-nt. Immediately after restarting the server, it worked, but then after a few minutes I tried to ALTER another field in the table, and it had the same problem. So I restarted the server again, it went through, but the problem persisted. I checked the file permissions, but everyone has full control to the files. The table now looks like this: CREATE TABLE postcodes ( id mediumint(8) unsigned NOT NULL auto_increment, postcode char(6) NOT NULL default '', plaats smallint(5) unsigned NOT NULL default '0', straat mediumint(8) unsigned NOT NULL default '0', low mediumint(5) unsigned NOT NULL default '0', high mediumint(5) unsigned NOT NULL default '0', parity enum('0','1','2') NOT NULL default '2', PRIMARY KEY (id), KEY postcode (postcode) ) TYPE=MyISAM; It has 570,441 rows. Is this a bug in MySQL, or am I doing something wrong? I was using phpMyAdmin to do the changes, but I don't think that should make any difference. Regards, Dirkjan Ochtman P.S. I really dislike the spam/off-topic bot at [EMAIL PROTECTED] It doesn't want this email, and that gives me a kind of we-don't-want-help-even-if you-really-try-to-describe-the-problem kind of feeling. - 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: file permissions problem on ALTER TABLE
Hmm, okay, but isn't the 3.23 supposed to be stable and thus more bugless than a gamma like 4.0.7? And also, I was wondering when 4 is going to be released as stable. Looking over the changelogs, it shouldn't be too long, right? Zak: thanks for the advice. I got real pissed off about it, since it seems like a real bug. :) But I guess it helps pretty good. Regards, Dirkjan - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Dirkjan Ochtman [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 10, 2003 11:45 PM Subject: Re: file permissions problem on ALTER TABLE Dirkjan, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem, neither on Win98, Win2K, nor Linux. I did have problems like the ones you describe with 4.0.1, 4.0.3 and 4.0.4 under Win98 and Win2K. Using 4.0.7 now und Win98 and Win2K, the ALTER TABLE problems have gone. Reporting this problem to the list, I heard strange advices like switch lower_case_table_names to 0. I believe it's a MySQL on Win bug with the 4.0.x versions mentioned above, and it might also affect 3.23 version after 3.23.49. My advice is: Update, MySQL 4.0.7 is real funky :) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Dirkjan Ochtman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 7:40 PM Subject: Bug: file permissions problem on ALTER TABLE Hi there, I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a weird problem: when trying to ALTER a TABLE, MySQL said that it no permissions to rename the *.myi file for that table. I kept encountering this problem (trying to go from VARCHAR(6) to CHAR(6) for an index field), but it would only work after I restarted the mysqld-max-nt. Immediately after restarting the server, it worked, but then after a few minutes I tried to ALTER another field in the table, and it had the same problem. So I restarted the server again, it went through, but the problem persisted. I checked the file permissions, but everyone has full control to the files. The table now looks like this: CREATE TABLE postcodes ( id mediumint(8) unsigned NOT NULL auto_increment, postcode char(6) NOT NULL default '', plaats smallint(5) unsigned NOT NULL default '0', straat mediumint(8) unsigned NOT NULL default '0', low mediumint(5) unsigned NOT NULL default '0', high mediumint(5) unsigned NOT NULL default '0', parity enum('0','1','2') NOT NULL default '2', PRIMARY KEY (id), KEY postcode (postcode) ) TYPE=MyISAM; It has 570,441 rows. Is this a bug in MySQL, or am I doing something wrong? I was using phpMyAdmin to do the changes, but I don't think that should make any difference. Regards, Dirkjan Ochtman P.S. I really dislike the spam/off-topic bot at [EMAIL PROTECTED] It doesn't want this email, and that gives me a kind of we-don't-want-help-even-if you-really-try-to-describe-the-problem kind of feeling. - 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
Permissions problem
Hi, I have a server running 3.23.41 on Redhat 7.1. The problem is that I can't access a database as a local user, but I can as a remote user. That is, on the local machine I get this: /usr/bin/mysqladmin -u tpdb -p= create fred /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'tpdb@localhost' (Using password: YES)' whereas if I access the machine from another Linux box: /usr/bin/mysqladmin -h lowenbrau -u tpdb -p= create fred it works. If I do it as the MySQL root user on the local machine that works OK. I assume something's wrong with my local tpdb user. The permissions are set as follows (after a lot of faffing about - I'm not suggesting these are optimal settings, or the ones I should have): localhost root all Ys lowenbrau.my.domain root all Ys lowenbrau.my.domain tpdb all Ys % tpdb all Ys localhost tpdb all Ys I've reloaded (and actually restarted) the server, but it won't play. There's nothing in the db table except a couple of test database entries. I'm reading up on security issues, but I have someone waiting on this, so if anyone could give me a pointer as to what I've done wrong, I'd much appreciate it. -- 8:32am up 1 day, 1:09, 1 user, load average: 0.33, 0.16, 0.05 - 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: Permissions problem
Since -p= is not valid syntax, it should not work. There is no equal sign after the -p, and no space between the p and the password which needs no quotes. If you have no password leave out the -p option. Derek Fountain wrote: Hi, I have a server running 3.23.41 on Redhat 7.1. The problem is that I can't access a database as a local user, but I can as a remote user. That is, on the local machine I get this: /usr/bin/mysqladmin -u tpdb -p= create fred /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'tpdb@localhost' (Using password: YES)' whereas if I access the machine from another Linux box: /usr/bin/mysqladmin -h lowenbrau -u tpdb -p= create fred it works. If I do it as the MySQL root user on the local machine that works OK. I assume something's wrong with my local tpdb user. The permissions are set as follows (after a lot of faffing about - I'm not suggesting these are optimal settings, or the ones I should have): localhost root all Ys lowenbrau.my.domain root all Ys lowenbrau.my.domain tpdb all Ys % tpdb all Ys localhost tpdb all Ys I've reloaded (and actually restarted) the server, but it won't play. There's nothing in the db table except a couple of test database entries. I'm reading up on security issues, but I have someone waiting on this, so if anyone could give me a pointer as to what I've done wrong, I'd much appreciate it. - 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
Permissions Problem
Hi; I get this error when I try to access a database as root: mysql use antigo; Can't read dir of './antigo/' (Errcode: 13) What does this mean and how do I fix it? TIA, BenO - 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
permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with permissions (i think) I just set up MySQL for private developement at home with PHP and created a db 'mydb' and granted all privs to nick@localhost Now, I can 'USE mydb' from the command line but if I try to do the same from a php script I get 'Access denied for user: '@localhost' .. Can somebody please tell me what to do? Many thanks... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZZO4HpvrrTa6L5oRAv4RAJ9duXHJqZfzZ9Oqe35I0rDvclHdIACePmJ+ hCYzY9nxo9GCX0lCNF4S+kk= =Tzyb -END PGP SIGNATURE- - 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: permissions problem
* and then Paul DuBois declared BTW er... I have your book here :) Ah. Well, in *that* case, check p429 and pp464-465. You may be getting bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access denied to user apache@localhost What next Paul? Much thanks BTW -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' table, and have you deleted the entries for user='' and run FLUSH PRIVILEGES? Certainly have. - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZbGfHpvrrTa6L5oRAmGHAJ4i/zpcnuo+l9NZedwdRi1s923tVACfV2v/ YUD5rUO5rge/dadTNFfbN0c= =n7Zo -END PGP SIGNATURE- - 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: permissions problem
At 0:19 +0100 2/10/02, Nick Wilson wrote: * and then Paul DuBois declared BTW er... I have your book here :) Ah. Well, in *that* case, check p429 and pp464-465. You may be getting bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access denied to user apache@localhost What next Paul? Do you have an entry for user apache, host localhost in the user table, and have you deleted the entries for user='' and run FLUSH PRIVILEGES? Much thanks BTW -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
At 23:31 +0100 2/9/02, Nick Wilson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared Note that the message doesn't include a user name in front of the '@'. Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_connect($host, $user, $pass); Is that what you mean? Okay, then it's not that, at least if $user has a non-empty value. :-) BTW er... I have your book here :) Ah. Well, in *that* case, check p429 and pp464-465. You may be getting bit by the phenomenon described there. - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZaNXHpvrrTa6L5oRAiPrAJ435aYGm+c3twUrFMzLHfVB+qMkeQCfXGHM 2GcGatSYMx2pQo7kXUjWx58= =1N7q -END PGP SIGNATURE- - 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 - 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: permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared Note that the message doesn't include a user name in front of the '@'. Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_connect($host, $user, $pass); Is that what you mean? BTW er... I have your book here :) - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZaNXHpvrrTa6L5oRAiPrAJ435aYGm+c3twUrFMzLHfVB+qMkeQCfXGHM 2GcGatSYMx2pQo7kXUjWx58= =1N7q -END PGP SIGNATURE- - 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: permissions problem
At 22:25 +0100 2/9/02, Nick Wilson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with permissions (i think) I just set up MySQL for private developement at home with PHP and created a db 'mydb' and granted all privs to nick@localhost Now, I can 'USE mydb' from the command line but if I try to do the same from a php script I get 'Access denied for user: '@localhost' .. Note that the message doesn't include a user name in front of the '@'. Which it would if you were specifying one. Can somebody please tell me what to do? Many thanks... - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with permissions (i think) I just set up MySQL for private developement at home with PHP and created a db 'mydb' and granted all privs to nick@localhost Now, I can 'USE mydb' from the command line but if I try to do the same from a php script I get 'Access denied for user: '@localhost' .. Can somebody please tell me what to do? Many thanks... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZZO4HpvrrTa6L5oRAv4RAJ9duXHJqZfzZ9Oqe35I0rDvclHdIACePmJ+ hCYzY9nxo9GCX0lCNF4S+kk= =Tzyb -END PGP SIGNATURE- - 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: permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared Note that the message doesn't include a user name in front of the '@'. Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_connect($host, $user, $pass); Is that what you mean? BTW er... I have your book here :) - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZaNXHpvrrTa6L5oRAiPrAJ435aYGm+c3twUrFMzLHfVB+qMkeQCfXGHM 2GcGatSYMx2pQo7kXUjWx58= =1N7q -END PGP SIGNATURE- - 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: permissions problem
At 23:31 +0100 2/9/02, Nick Wilson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared Note that the message doesn't include a user name in front of the '@'. Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_connect($host, $user, $pass); Is that what you mean? Okay, then it's not that, at least if $user has a non-empty value. :-) BTW er... I have your book here :) Ah. Well, in *that* case, check p429 and pp464-465. You may be getting bit by the phenomenon described there. - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZaNXHpvrrTa6L5oRAiPrAJ435aYGm+c3twUrFMzLHfVB+qMkeQCfXGHM 2GcGatSYMx2pQo7kXUjWx58= =1N7q -END PGP SIGNATURE- - 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: permissions problem
At 22:25 +0100 2/9/02, Nick Wilson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with permissions (i think) I just set up MySQL for private developement at home with PHP and created a db 'mydb' and granted all privs to nick@localhost Now, I can 'USE mydb' from the command line but if I try to do the same from a php script I get 'Access denied for user: '@localhost' .. Note that the message doesn't include a user name in front of the '@'. Which it would if you were specifying one. Can somebody please tell me what to do? Many thanks... - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
* and then Paul DuBois declared BTW er... I have your book here :) Ah. Well, in *that* case, check p429 and pp464-465. You may be getting bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access denied to user apache@localhost What next Paul? Much thanks BTW -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
At 0:19 +0100 2/10/02, Nick Wilson wrote: * and then Paul DuBois declared BTW er... I have your book here :) Ah. Well, in *that* case, check p429 and pp464-465. You may be getting bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access denied to user apache@localhost What next Paul? Do you have an entry for user apache, host localhost in the user table, and have you deleted the entries for user='' and run FLUSH PRIVILEGES? Much thanks BTW -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: permissions problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' table, and have you deleted the entries for user='' and run FLUSH PRIVILEGES? Certainly have. - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZbGfHpvrrTa6L5oRAmGHAJ4i/zpcnuo+l9NZedwdRi1s923tVACfV2v/ YUD5rUO5rge/dadTNFfbN0c= =n7Zo -END PGP SIGNATURE- - 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
Permissions Problem
Ben, Tuesday, February 05, 2002, 11:42:50 PM, you wrote: BO Hi; BO I get this error when I try to access a database as root: BO mysql use antigo; BO Can't read dir of './antigo/' (Errcode: 13) BO What does this mean and how do I fix it? That means your unix user doesn't have privileges on './antigo/' dir. BO TIA, BO BenO -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Permissions Problem
Hi; I get this error when I try to access a database as root: mysql use antigo; Can't read dir of './antigo/' (Errcode: 13) What does this mean and how do I fix it? TIA, BenO - 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