mediumint(6) problem
Hi all, I have a small problem - I have the following table with numetic type. In my table is mediumint(6), but I can to insert value 11223344. I thougth the maximum value for mediumint(6) is 99. Do you have some idea what I should to do to be able insert value 99 as a maximum for my field? My table: CREATE TABLE `table` ( `id_a` mediumint(6) unsigned NOT NULL default '0', `id_b` mediumint(6) unsigned NOT NULL default '0', `id_c` mediumint(6) unsigned NOT NULL default '0', `area` char(2) NOT NULL default '', `group` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id_a`,`id_a`,`id_b`) ) TYPE=MyISAM Background: MySQL version 3.23.49 on Red Hat Linux 7.3. Thank tou very much for your help. Regards, Jan - 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: Problem Installing on RH 7.3
I am not sure, but are you sure that mysqld is running as a root? Or as a mysql (user) and mysql (group). Try to check rights of the mysqld user. Jan - Original Message - From: Richard Fox [EMAIL PROTECTED] To: Noamn [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 5:44 PM Subject: Re: MySQL: Problem Installing on RH 7.3 The mysqld.log file says: 020717 13:05:05 mysqld started 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020717 13:05:05 mysqld ended But I do see the host.frm file: -rw-rw1 root root 8958 Jul 17 13:04 /var/lib/mysql/mysql/host.frm How did you fix this problem? I do have the /var/lib/mysql/mysql.sock file... Thanks Rich I'm near enough in the same position as you are. Check the file /var/log/mysqld.log to see what the problem is. I had a problem accessing the file './mysql/host.frm', but I think that I've fixed this now. What happens when you try the 'mysql' command? I get the response can't connect to local MySQL server through socket '/var/usr/mysql/mysql.sock' And indeed there is no such file. Do you have this file? -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 10:41 PM To: [EMAIL PROTECTED] Subject: MySQL: Problem Installing on RH 7.3 The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich sql - 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: user
Dear Michal, I am not sure, but I think you can create an user will all the rights in mysql - user (database - table) - this will solve your problem with full access to all databases. And then you can use other tables in database mysql to define rights of this user to table user. Have a look to manual pages: 4.2 General Security Issues and the MySQL Access Privilege System http://www.mysql.com/doc/P/r/Privilege_system.html Regards, Jan - Original Message - From: Michal Dvoracek Sent: Monday, July 15, 2002 7:40 AM Subject: user Hello, is possible to create user which will be not able to create other users and will have full access to all existing databases and databases which will be created in future? Thank you. Regards, Michal Dvoracek - 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 in rpm from RH 7.3
I have receive an answer that there is a bug in MySQL rpm packages in Red Hat 7.3 distribution. I have tried to find any information about it but I didn't find anything about it. There is no errata on Red Hat web site, and also other sources hasn't any information about the bug in Red Hat 7.3 MySQL rpm packages. Do you have some info about a MySQL rpm bug in Red Had 7.3? Thank you, Jan - Original Message - Hi All, I am running MySQL 3.23.49 on Red Hat Linux 7.3 (installed from rpm included in RH distribution). I am using ext3 file system. In my my.cfg is skip-locking. The system is Intel i810, Intel Celeron 433 MHz, 64 MB RAM. It is used only as a database server which is accessable only from our web (apache, php). I would like to do some operation automatickly and periodicly (with a crond): - check all databases / tables - optimize all databases / tables According to documentation (http://www.mysql.com/doc/C/o/Command-line_options.html) I can't use myisamchk, as long as mysqld is running. I have try somethong like this: mysqld stop myisamchk -swr /path/to/datadir/*/*.MYI myisamchk -swm /path/to/datadir/*/*.MYI mysql start But I don't want to stop sql server every time. Could you help me how to solve this issue? Has somebody experience with MySQL on RedHat 7.3 with ext3? Thanks, Jan - 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
mysqld / RH 7.3 / skip-locking
Hi All, I am running MySQL 3.23.49 on Red Hat Linux 7.3 (installed from rpm included in RH distribution). I am using ext3 file system. In my my.cfg is skip-locking. The system is Intel i810, Intel Celeron 433 MHz, 64 MB RAM. It is used only as a database server which is accessable only from our web (apache, php). I would like to do some operation automatickly and periodicly (with a crond): - check all databases / tables - optimize all databases / tables According to documentation (http://www.mysql.com/doc/C/o/Command-line_options.html) I can't use myisamchk, as long as mysqld is running. I have try somethong like this: mysqld stop myisamchk -swr /path/to/datadir/*/*.MYI myisamchk -swm /path/to/datadir/*/*.MYI mysql start But I don't want to stop sql server every time. Could you help me how to solve this issue? Has somebody experience with MySQL on RedHat 7.3 with ext3? Thanks, Jan - 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