Problems making a mysql.so file

2004-07-21 Thread Jough P
Greetings all, I tried the PHP list with this one and can't seem to get an answer so I thought I'd try here. I upgraded from MySQL 3.23 to 4.0. I placed all the new mysql files in /usr/local/mysql/bin, /usr/local/mysql/include and /usr/local/mysql/lib. I compiled PHP5 and it is still using

Upgrade from 3.23 to 4.0 - mysql.sock error

2004-07-14 Thread Jough P
Greetings all, I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved the old installation to a directory called old_mysql in my home directory. I can start the new installation using mysqld_safe . Now, when I try to do something like: /new/install/mysqladmin -u root -p version

Re: Upgrade from 3.23 to 4.0 - mysql.sock error

2004-07-14 Thread Jough P
Okay, so what I did to solve this was: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock That seems like a bit of a hack though. The my.cnf file has this line: socket=/var/lib/mysql/mysql.sock Anyone know why it's looking in /etc ? On Jul 14, 2004, at 4:53 PM, Jough P wrote: Greetings all, I

File_priv syntax?

2004-01-16 Thread Jough P
Greetings all, I'm trying to grant a user the file privelege and am getting error messages. Here's my SQL statement mysql GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY 'password123'; It gets the following error: ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual