Why is Host option Failing?

I've recently reloaded my box (PCLinuxOS). The machine name on the network is photon. I've set this in the hosts table, in hostname, and on the network. in my.cnf I have the following 2 lines: bind-address= photon bind-address= localhost The "skip-networking" directive

Re: Why is Host option Failing?

What user are you at the time you are running these tests. Would I be correct in guessing 'root'? The reason localhost works is because, in some distros, root is enabled localhost with no password .. which is dangerous enough.. granting root@'%" would be an invitation to disaster.. >From that sa

phpMyAdmin Privileges Query

Hello, just wondering if anyone can advise the query that phpMyAdmin generates to list all the privileges for a specific database. What I'm after is an output like: +-++--+-+ |User | Host| Type | Privileges | +-

Re: Why is Host option Failing?

On Sunday, July 04, 2010 06:36:00 pm you wrote: > What user are you at the time you are running these tests. Would I be > correct in guessing 'root'? > > The reason localhost works is because, in some distros, root is > enabled localhost with no password .. which is dangerous enough.. > granting

Got error 139 from storage engine (InnoDB)

Hi All, I have received error message "ERROR 1030 (HY000) at line 167: Got error 139 from storage engine" when importing dump database to MySQL server. The MySQL server is using InnoDB. I have google it and it's something problem on exceeding a row-length limit in the InnoDB table. Any have idea