Can't download 4.0.2 for Solaris...:(
Hi, I'd like to download 4.0.2 for SPARC from http://www.mysql.com/Downloads/MySQL-4.0/mysql-4.0.2-alpha-sun-solaris2.8-sp arc.tar.gz but I can't and I don't know why... Could you help me please, where should I look for a downloadable version? Thanks in advance! Regards; Istvan - 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
How to lock specified fields?
Hi, Can I lock a field somehow against modification? So I have a table and it has 4 fields. I want to lock the same two fields in two records, to not enable to modify those fields. Can I do it somehow? Thanks in advance! Regards; Istvan sql, mysql - 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
Compilation problem on Solaris 8
Hi I've tried to compile the latest mysql source on our Solaris 8 SPARC server and gcc 2.95.3, but make hangs up with these errors; -I/usr/share/src/mysql-3.23.51/include -DHAVE_RWLOCK_T -c sql_lex.cc sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once sql_lex.cc:85: for each function it appears in.) sql_lex.cc:87: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX *, unsigned int, bool)': sql_lex.cc:168: implicit declaration of function `int get_hash_symbol(...)' sql_lex.cc:168: initialization to `SYMBOL *' from `int' lacks a cast *** Error code 1 make: Fatal error: Command failed for target `sql_lex.o' Current working directory /usr/share/src/mysql-3.23.51/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /usr/share/src/mysql-3.23.51/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /usr/share/src/mysql-3.23.51 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Could you help me, please what should I set or install to get a working mysql server? Thanks in advance! Regards; Istvan - 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
Permission denied for download???
Hi I'd like to download mysql-3.23.51-sun-solaris2.8-sparc.tar.gz from mysql.com, but the server doesn't allow me to get the file. What's wrong with it? Thanks in advance! Regards; Istvan - 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
4.0 When?
Hi, Is there a roadmap for mysql 4.0? We'd like to upgrade our MySQL DB server to another one which can use some useful techniques eg. sub-selects, transaction handling, etc. I like mysql very much and I know that in 4.0 these techs will be implemented. But I don't know when will this new server released... Thanks in advance! Regards; Istvan - 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: 4.0 When?
Oh, not the alpha, but the stable version, of course! Is there a roadmap for mysql 4.0? We'd like to upgrade our MySQL DB server to another one which can use some useful techniques eg. sub-selects, transaction handling, etc. I like mysql very much and I know that in 4.0 these techs will be implemented. But I don't know when will this new server released... Thanks in advance! Regards; Istvan - 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
To ban mysql server user login
Hi, As I see after the installation mysql server user can login because it has bash shell in passwd file; mysql:x:100:101:MySQL server:/var/lib/mysql:/bin/bash Can I change it to /sbin/nologin without so much as it hangs up? Or does this user handle the mysql client logins? Thanks in advance! Regards; Istvan - 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
UTF-8 on a field?
Hi I need to set up the character coding of a field to UTF-8 in our MySQL 3.23.49a. The database now runs on ISO 8859-2 and I don't want to set the new character coding on the whole database just on the field. Can I do it somehow? Thanks in advance! Regards; Istvan - 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
query mysql db from a bash script?
Hi Is that possible to query the database from a bash script? I need some informations from a table, and it looks the easiest way. How can I connect, use a database, and query a table? Thanks in advance! Regards; Istvan - 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
Many processes in SHOW PROCESSLIST;
Hi, We use mysql 1.23.47 as a database for our PHP based accounting system. We use mysql_pconnect() to get a connection to the DB. This morning we couldn't log in because mysql sent back a 'too many open connection!' (or someting like that) error message. If I use the command SHOW PROCESSLIST than I can see many 'Sleep' processes. If I try to kill some processes by KILL processnumber than newer processes appear in the list. Is there any way to kill all of the hanging processes? And why are so many processes if we use mysql_pconnect() which uses the same connection what the PHP user opened before? Thanks in advance! Regards; Istvan - 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: Empty mysql.user entries???
Reznichenko, Wed, 13 Feb 2002 15:02:01 PM, you wrote: TI After the default mysql-3.23-47 installation, TI there are two entries in the mysql.user table TI where the User and Password fields are empty. TI I'd like to know what is the purpose of these TI records? TI The first has a 'localhost' entry in the Host field TI and the second one has the 'hostname'. TI Can I delete them, or will this crash the database? These are default records in mysql.user and all priv_types are set to 'N'. These rows are corresponding to default user in mysql. OK. But who is that 'default user'? As I know just the root and an anonymous user's created as the initial MySQL accounts. At least I've found it in the doc; An anonymous user is created that can do anything with databases that have a name of 'test' or starting with 'test_'. Connections must be made from the local host. This means any local user can connect without a password and be treated as the anonymous user. So it would be that default user what you wrote about? Is it like scott/tiger in ORACLE? We don't have any real database, named 'test' or 'test_*', just what the MySQL installation set. Can I delete that default user and 'test' database from our public DB, just after the installation? Whatsoever, what is the purpose of that default database named 'test'? I think anyone can create a database if she/he wants to try mysql. This means any local user can connect without a password and be treated as the anonymous user. I'm afraid we don't need this feature. Thanks in advance! Regards; Istvan - 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
Empty mysql.user entries???
Hi, After the default mysql-3.23-47 installation, there are two entries in the mysql.user table where the User and Password fields are empty. I'd like to know what is the purpose of these records? The first has a 'localhost' entry in the Host field and the second one has the 'hostname'. Can I delete them, or will this crash the database? Thanks in advance! Regards; Istvan - 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
How to login after password setup?
Hi, I tried to set the root password in the mysql db; update user set Password='password' where User='root'; The user table looks like this; | localhost | root | password | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | server| root | password | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | 192.168.200.0/255.255.255.0 | root | password | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | So, it has set the passwords and then I made a flush privileges; Since then, I can not login as root... ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) I don't understand. What's wrong with this? Thanks in advance! Regards, Istvan - 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
Securing MySQL?
Hi I want to secure our MySQL DB as much as possible. In the freshly installed DB I have found two records in the mysql.user which has no value in the User and Password field; --+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_pri v | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+---+--+-+-+ -+ | localhost | root | 1500fab725e6f823 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | server | root | 1500fab725e6f823 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | server | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | Should I delete these records? Or are these for any administrative purposes? Thanks in advance! Regards, Istvan - 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
What should I set in the mysql.user?
Hi We develop a commercial site, where the mysql db, and the apache will run on the same machine. We use PHP to process the data. What should I set in the mysql.user and mysql.db tables into the Host field if I want to enable the connections just from the same server not from everywhere? '%', or 'localhost', or 'www.servername.com' ??? Thanks in advance! Regards, Istvan - 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
Usage of SET ?
Hi, Red Hat 7.2, MySQL 3.23.47-1 I'd like to set up the character set on one of our table. I've found an example of the SET command in the mysql documentation, but I'm afraid I can't use it; SET [OPTION] SQL_VALUE_OPTION= value, ... set character set=hungarian on table; ERROR 1115: Unknown character set: 'hungarian' How can I turn on the hungarian language support? And should I use the SET command in the mysql client, or in mysqladmin? Thanks in advance! Regards: Istvan - 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
Two questions
Hi Q1: I've upgraded our mysql db from 3.23.43-1 to 3.23.46-1 on our Red Hat Linux 7.2 I used the binary rpm distribution. I had to keep our database up and running while I upgrading so I used the --force switch to upgrade the server (the old client always complained for dependecies problem). The database has been working well since then, but I can't complie the PHP because it sends a lot of error messages complaining to the libmysqlclient.a: /usr/lib/mysql/libmysqlclient.a(dbug.o): In function `_db_unlock_file': dbug.o(.text+0xaf4): multiple definition of `_db_unlock_file' /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o)(.data+0x1701): first defined here /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o): In function `my_strnncoll_tis620': ctype-tis620.o(.text+0x244): multiple definition of `my_strnncoll_tis620' and so on. How can I query the version number of the libmysqlclient.a? I think something went wrong under the upgrading process. Q2: Because I used rpm to install the server I don't have mysql log. I found some great examples in the /usr/share/mysql/ but as I see it doesn't contain entries for logging. What should I write into the my.cnf to be able to see what's happen in our db? Thanks in advance! Regards Istvan - 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
lib error?
Hi I'd like to compile the new PHP 4.1.0, but it always stops at the libmysqlclient.a with these error messages: /usr/lib/mysql/libmysqlclient.a(dbug.o): In function `_db_unlock_file': dbug.o(.text+0xaf4): multiple definition of `_db_unlock_file' /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o)(.data+0x1701): first defined here /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o): In function `my_strnncoll_tis620': ctype-tis620.o(.text+0x244): multiple definition of `my_strnncoll_tis620' /usr/lib/mysql/libmysqlclient.a(ctype.o)(.data+0x684): first defined here /usr/lib/mysql/libmysqlclient.a(ctype.o): In function `find_compiled_charset_by_name': ctype.o(.text+0x0): multiple definition of `find_compiled_charset_by_name' /usr/lib/mysql/libmysqlclient.a(array.o)(.text+0x78): first defined here /usr/lib/mysql/libmysqlclient.a(array.o): In function `alloc_dynamic': array.o(.text+0xc4): multiple definition of `alloc_dynamic' and so on... We use the latest stable mysql (3.23.46-1). Could you help me, what's wrong with it? Thanks in advance! Regards Istvan - 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 log?
Hi How can I set up our mysql server to write its logs into a log file? Thanks in advance! Regards Istvan - 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