installation

2002-10-22 Thread Alex Jarvis
I'm installing mysql on RedHat 7.1 linux. I downloaded the relevant rpms (version 3.23.36-1) and installed them. But I think there was already a source rpm installed (mysql was ready to be installed from a source distribution but hadn't been). When I try to run mysql_install_db I get

AUTO_INCREMENT problem

2002-08-02 Thread Alex Jarvis
I've written a C program which inserts new entries into a table with an auto_incremented column. In testing it I created several entries, which I then deleted by connecting to mysql from the unix command line. The problem is, when I reset the last_insert_id from the mysql prompt, it

chown: 'mysql': invalid user

2002-07-11 Thread Alex Jarvis
To summarize: I was getting a cannot connect through socket... error. It would appear that the server is not running and the socket doesn't exist. So I tried to start the server (as root) using safe-mysqld and mysql.server start, but in either case I recieve the message: chown:

can't connect

2002-07-10 Thread Alex Jarvis
So, I had mysql up and running a week ago, but at some point the system on which it was installed was rebooted. Now when I try to connect I get a Cannot connect through socket 'var/lib/mysql/mysql.sock' error message. I've read some of the archives and found similar problems. The