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;

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

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

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,

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

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

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

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

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

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

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

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

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

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 |

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? '%',

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

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).

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'

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)