Cygwin and High School Lab
A couple of people have wondered why I'm using Cygwin with MySQL and seem to think I'm trying to use the Linux version of MySQL on Windows. I've installed the latest Windows version of MySQL. I'm using Cygwin as the launcher rather than the Windows command prompt, mostly because it's easier for me to set up environment variables correctly, to run SSH, Tomcat, etc. from a Unix-y prompt rather than a DOS prompt. Since when I type mysql it's actually mysql.exe that gets run, I don't think Cygwin could be the culprit in the crash, but I'm going to try running MySQL from the Windows command prompt today to see if that makes a difference. Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Crash on Windows XP SP2 when not run as an administrator
I've tested mysql in my high school lab running from an administrator and from a student account, both from within the Cygwin terminal, and at the Windows command prompt. From the administrator account, it runs fine for hours. From the student account, it promptly (within 15 seconds or so) crashes with the same error each time. I managed to write down the error: -- Debug Assertion Failed! Program: mysqld.exe File: ftell.c Line: 50 Expression: stream != NULL --- This pretty successfully crashes the MySQL server so that if you're running the client, you get messages about the server being inaccessible and such. Is there something that non-administrators need access to that could be causing the problem? Could it be an SP2 issue? I have access to a server where I can set up student accounts so that we can do the tutorial I have planned, but I do, eventually, need to be able to run MySQL on my lab machines. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem running MySQL in high school lab
I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had the permissions set wrong and my students couldn't start the server, but I fixed that, and now mysqld works fine. Unfortunately, if you then mysql -u root, after a rather short period of time, the program crashes and pops an error message to the screen. The message, which I should have written down but didn't, says that an assertion has failed in ftell.c (not sure about the filename, but the gist is right) and stream != NULL (that I'm sure of) and then the program dies. I don't have similar problems when I'm logged in as me (which has Administrator privileges) or the machine Administrator. It must be a permissions problem, but I don't know what I need to give the students to prevent it. The MySQL stuff on the local machines need not be secure, so I've given full access to all users in the entire /cygwin/usr/local/ directory and its subdirectories, which is where I installed MySQL and all the other packages we're going to be playing with. There are some kids in there who don't need the temptation of being logged in as an Administrator, and since we're going to be using JDBC later for which the MySQL server will need to be running almost constantly in the background, I'd like to get this resolved with the least amount of temptation. The lab is all Windows XP Professional machines, and the students log into a domain hosted by a server in another teacher's lab. Any ideas appreciated, Todd P.S. If you could cc me any replies, I'd appreciate it, since I read the list on digest. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select help
I'm new, too, so someone correct me if I'm wrong, but... if you make it an ENUM field in a table you can store it using the value in the selection, retrieve it as the same value, and still get all the advantages of numeric storage. Todd On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote: Hello list, I'm really new to mysql and databases in general. I have a select form that contains a very long list of options, and what I want to do is store the selected item as a number instead of the items name in order to speed up searches. My problem comes when a search is done and I can't figure out how to return the query with the items name not the number. Any suggestions and help is greatly appreciated. Dan Cox -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't start MySQL on Mac OS X
Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OS X downloads
There are two sets of binary downloads at mysql.com for Mac OS X. They're different sizes, but both say OS 10.2. Is that a typo? Is one of the two for OS 10.1, and could I have downloaded the wrong one and could that be the reason I can't get mysql to start? Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
I think mysqld_safe is just a shell script, so you might be able to go through there and see if you can find where /usr/local/mysql is defined. On the other hand, I just looked, and it looks like it's smart enough to figure out if you've moved the installation directory. Try cd-ing to the place where your new version is and type ./bin/mysqld_safe. That may not work, because another copy of mysql may already be running somewhere. Something else to check: make sure mysqld is executable by doing a ls -l on the directory it's in. We're far past my knowledge at this point (actually, we were at the limit of my knowledge when I told you to try cd-ing and re-typing the command) and I'm just throwing out possibilities... Todd On Wednesday, July 2, 2003, at 08:57 PM, [EMAIL PROTECTED] wrote: Todd, It didn't help. Here is the message: $ cd /usr/local/mysql $ ./bin/mysqld_safe The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. $ --- It worked fine until yesterday. SA told me he had rebuilt /user/local directory this morning. All the files are still there after the build. Actually I have two versions of mysql. I would like to start mysqld using different version of mysql that I installed in a different location. I wonder where the path '/usr/local/mysql/libexec/mysqld' stored in the system. Can we change this path somewhere in the parameter file? Thanks, song -Original Message- From: Todd O'Bryan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 6:56 PM To: Xu, Song PH/US/EXT Cc: [EMAIL PROTECTED] Subject: Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: About JDBC
It should be enough to place the .jar file in the jre/lib/ext folder inside your Java installation folder. If you don't want to do that, you could modify your CLASSPATH environment variable to include wherever you decide to place the .jar. Todd On Saturday, April 5, 2003, at 09:05 AM, 徐祿政 wrote: Sorry~ I have a problem about JDBC now, I use mySQL as my database and tomcat as my server I downloaded the JDBC driver (mysql-connector-java-3.0.6-stable.zip) and unziped it, but now I don't how to use it? How to let my jsp pages connect to my database Would u tell me how to do?? thanks a lot!! L.c.Hsu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to mysql server
Try the following cd /usr/local/mysql ./bin/mysqld_safe and see if that starts up the server. If it doesn't, check to make sure you don't have a proxy set in your internet configurations. Todd On Saturday, April 5, 2003, at 12:00 PM, Peter Gumbrell wrote: I have installed mysql on Mac OS X. when I attempt to access it either through a php page or through Terminal, I receive this message; Can't connect to local MySQL server through socket '/tmp/mysql.sock' I have just switched to a Mac and am unfamiliar with many aspects of unix. I read something about creating a symbolic link but am unsure how to do this and if this will solve the problem. Any help would be greatly appreciated. Peter [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: JDBC can't connect, but command line can...
OK. I'm an idiot. It suddenly hit me today that my code worked at home, but not at school. Then I remembered that we have a proxy server at school. I disabled the SOCKS proxy, and, sure enough, everything works now. There are disadvantages to just changing a Home/School setting, especially if you forget what all is involved in the switch. Color me stupid, Todd On Wednesday, April 2, 2003, at 10:56 AM, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Todd O'Bryan wrote: | I've managed to get mysql up and running again (I don't know how) but | JDBC won't connect to it. | | Here's my little simple code: | | import java.sql.*; | import java.io.*; | | public class MySQLTester { | | public static void main(String[] args) throws Exception { | Class.forName(com.mysql.jdbc.Driver); | System.out.println(Loaded Driver...); | | DriverManager.setLogWriter(new PrintWriter(System.out)); | | | Connection con = | DriverManager.getConnection(jdbc:mysql://localhost/test,tobryan1, | aoeuidhtns); | System.out.println(Got connection...); | | Statement s = con.createStatement(); | s.executeUpdate(CREATE TABLE students (login char(8), last | VARCHAR(20), first VARCHAR(20), + | nickname VARCHAR(20), course CHAR(4), period | INT)); | } | } | | And here's what happens: | | [iBook:18] java MySQLTester | Loaded Driver... | DriverManager.getConnection(jdbc:mysql://localhost/test) | trying | driver[className=com.mysql.jdbc.Driver,[EMAIL PROTECTED] | | and it hangs forever. | | - | I can connect to mysql using the same user name and password, however | | [iBook:20] mysql -u tobryan1 -p | Enter password: | Welcome to the MySQL monitor. Commands end with ; or \g. | Your MySQL connection id is 9 to server version: 4.0.12-standard | | Type 'help;' or '\h' for help. Type '\c' to clear the buffer. | | mysql use test; | Database changed | mysql show tables; | Empty set (0.00 sec) | | mysql | - | I've searched for info on troubleshooting the JDBC connection and | skimmed the O'Reilly book by George Reese, but to no avail. | | Should I just give up, or is there something I can do to figure out | what's going wrong? | | Thanks, | Todd When you don't specify a hostname (and 'localhost' doesn't count, use '127.0.0.1') to the mysql commandline client, it uses Unix domain sockets to connect to the server. JDBC has to use TCP/IP, because Java doesn't have support for Unix domain sockets. What happens if you do: mysql -h 127.0.0.1 -u tobryan1 -p What happens if you telnet to 'localhost 3306'...does the server answer, or do you just sit forever? If neither of these work, than neither will JDBC...do you have a firewall setup on your machine that would block 127.0.0.1? Was mysqld started with '--skip-networking' ??? -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma ~__ ___ ___ __ ~ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] ~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java ~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ~___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+iwg5tvXNTca6JD8RAuwwAKC86/iQI35O+DYV89O4bAdDnDf8zACgma1w HdDjewEWMRj5/0gYmM9MARo= =ay/F -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: JDBC can't connect, but command line can...
When you don't specify a hostname (and 'localhost' doesn't count, use '127.0.0.1') to the mysql commandline client, it uses Unix domain sockets to connect to the server. JDBC has to use TCP/IP, because Java doesn't have support for Unix domain sockets. What happens if you do: mysql -h 127.0.0.1 -u tobryan1 -p It works. [iBook:1] mysql -h 127.0.0.1 -u tobryan1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 to server version: 4.0.12-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql What happens if you telnet to 'localhost 3306'...does the server answer, or do you just sit forever? Actually, something happens that I don't understand: [iBook:3] telnet localhost 3306 Trying ::1... telnet: connect to address ::1: Connection refused Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 0 4.0.12-standardTwz!2tvp, Bad handshakeConnection closed by foreign host. --- 4.0.12 looks like it's MySQL, but I have no idea what this means. This at least looks like it should tell somebody something. Any idea where to go next? Thanks! Todd On Wednesday, April 2, 2003, at 10:56 AM, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Todd O'Bryan wrote: | I've managed to get mysql up and running again (I don't know how) but | JDBC won't connect to it. | | Here's my little simple code: | | import java.sql.*; | import java.io.*; | | public class MySQLTester { | | public static void main(String[] args) throws Exception { | Class.forName(com.mysql.jdbc.Driver); | System.out.println(Loaded Driver...); | | DriverManager.setLogWriter(new PrintWriter(System.out)); | | | Connection con = | DriverManager.getConnection(jdbc:mysql://localhost/test,tobryan1, | aoeuidhtns); | System.out.println(Got connection...); | | Statement s = con.createStatement(); | s.executeUpdate(CREATE TABLE students (login char(8), last | VARCHAR(20), first VARCHAR(20), + | nickname VARCHAR(20), course CHAR(4), period | INT)); | } | } | | And here's what happens: | | [iBook:18] java MySQLTester | Loaded Driver... | DriverManager.getConnection(jdbc:mysql://localhost/test) | trying | driver[className=com.mysql.jdbc.Driver,[EMAIL PROTECTED] | | and it hangs forever. | | - | I can connect to mysql using the same user name and password, however | | [iBook:20] mysql -u tobryan1 -p | Enter password: | Welcome to the MySQL monitor. Commands end with ; or \g. | Your MySQL connection id is 9 to server version: 4.0.12-standard | | Type 'help;' or '\h' for help. Type '\c' to clear the buffer. | | mysql use test; | Database changed | mysql show tables; | Empty set (0.00 sec) | | mysql | - | I've searched for info on troubleshooting the JDBC connection and | skimmed the O'Reilly book by George Reese, but to no avail. | | Should I just give up, or is there something I can do to figure out | what's going wrong? | | Thanks, | Todd -Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mac OS X package problems
In desperation I have restarted my machine a couple of times, and once I actually watched the start-up routine...this gave me a clue: In accord with the installation instructions, I used Marc Liyanages' startup item installer. Since then, I have removed the every vestige of my MySQL installation following the instructions given by Lenz Grimmer. BUT, At startup, the computer says something about starting a MySQL server. Could it be that the startup item is still trying to start mysqld even though it no longer exists and in the process is tying up port 3306? (I'm grasping at straws here. I tried manually installing the latest 3.0 version and when I tried to run safe_mysqld it said that libexec/mysqld did not exist, and, sure enough, there wasn't even a libexec directory.) Please, please, please, if anyone thinks they could get me to the point of having a running mysql system on OS X, I'd really appreciate the help. I teach high school, and I desperately need to set up a database of practice questions for my students who are taking the AP Computer Science exam. I'm working on Java programs to read in the questions and quiz students on questions they haven't successfully answered yet, but it's hard to be successful at that if I don't have a working mysql installation. Each student has entered 6 or 7 questions as an XML document, and I just have to get them into the database and set up a quiz program. Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Still Mac OS X problems (4.0.12)
OK. Everything was up and running thanks to what Lenz suggested earlier. I was even able to connect to the server using JDBC from the local machine. But then the Java connection, for no apparent reason, stopped working. Java apps would just stall without ever connecting, but I could still connect using the mysql command. I restarted my computer and now I get this error in the error log when I try to start the mysql server: 030331 18:43:27 mysqld started 030331 18:43:27 Can't start server: Bind on TCP/IP port: Address already in use 030331 18:43:27 Do you already have another mysqld server running on port: 3306 ? 030331 18:43:27 Aborting 030331 18:43:27 /usr/local/mysql/bin/mysqld: Shutdown Complete 030331 18:43:27 mysqld ended But, when I try connecting using mysql -u tobryan1 -p (tobryan1 is my user name, and it worked before), I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Help! If anybody has any idea how to fix this, I'd appreciate it. TIA, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't uninstall, reinstall, or otherwise get 4.0.12 to work on Mac OS X
I recently installed MySQL 4.0.12 on Mac OS X (using the package provided in the downloads section) and I must have corrupted something because I can't get the mysql command to work. I thought the easiest thing to do would be to uninstall the whole thing and start over, but I can't figure out how to do that. I went to Marc Liyanages' website and downloaded his uninstall script, but it seems that the default name of the package has changed since he wrote that script, and I don't know enough about shell scripts to do much. I have 3.23.52 up and running on another OS X computer, but I really need a working version on my iBook. Any help, pointers, or insight greatly appreciated! TIA, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OS X errors (using 4.0.12 package installer)
After removing every directory I could find related to MySQL, I used the OS X Package Installer to re-install MySQL. But I get the following error when I follow the instructions to start mysql (from the logfile): 030330 16:22:20 mysqld started 030330 16:22:21 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: Cannot continue operation. 030330 16:22:21 mysqld ended After some research, I was clever (?!) enough to chown all the files and directories in the mysql directory so that mysql is now the owner. I tried again and got this error: 030330 16:51:10 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 030330 16:51:11 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 030330 16:51:13 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 030330 16:51:14 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 030330 16:51:16 InnoDB: Started 030330 16:51:16 Fatal error: Can't open privilege tables: Table 'mysql.host' do esn't exist 030330 16:51:16 Aborting 030330 16:51:16 InnoDB: Starting shutdown... 030330 16:51:18 InnoDB: Shutdown completed 030330 16:51:18 /usr/local/mysql/bin/mysqld: Shutdown Complete 030330 16:51:18 mysqld ended Any idea what to do now? And shouldn't the installer be taking care of all of this semi-automatically? Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]