mysql won't start on new installation 10.04

[cdenley]

Ah thanks, I think we were writing our replies at the same time.
When I run either command I get:

mysql> GRANT ALL on table.* to root@% identified by 'temppassword';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right 
syntax to use near '* to root@% identified by 'temppassword'' at 
line 1

You need to substitute "table" with the table name you want to connect with, the username has to be in quotes, and the hostname has to be in quotes.

[senor_smile]

You need to substitute "table" with the table name you want to connect with, the username has to be in quotes, and the hostname has to be in quotes.

Thank you! I hadn't realized those were "variables" to be filled in. That worked like a charm.

[cdenley]

Thank you! I hadn't realized those were "variables" to be filled in. That worked like a charm.

That should be "database" not "table". I just realized my mistake.

[fixitdude]

Also check to see if it's "my.cnf" NOT "my.conf", it's easy to get that wrong and some places even show it that way.

[123fix]

I can give you better solution for installation.

i found great article about this
some fixes also there, auto configuration:

http://www.discusswire.com/mysql-ins...-ubuntu-10-04/