Maximum PC

Ok I am having a very hard time setting up MySQL for a LAMP machine. I have already installed PHP and Apache with no problems but as soon as MySQL is finished installing, I execute the following command, mysql -u root, but I get this error:


So I try to prompt for a password with mysql -u root -p. I type in the root password and I get this:


Can't figure out whats wrong here, cause I installed MySQL minutes before.

What did you do to install it? What OS? More info?

sudo apt-get install mysql-server

Its running on Ubuntu server.

When MySQL completes and releases the 5.x version of its product it will have matched and in some cases surpassed the major databases in basic SQL compliance and functionality. MySQL 5.0 is in advanced alpha testing. The three key add ons to 5.0 are stored procedures using the SQL 2003 standard syntax, cursors and a complete set of views. The performance enhancement include better support for in MEMORY tables plus added indexing options for user control. as well 5.0 will settle VARCHAR implementation differences, in fact moving closer to the defato standards.