Got error 139 from storage engine (InnoDB)

2010-07-04 Thread James Corteciano
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

Re: Why is Host option Failing?

2010-07-04 Thread Michael Satterwhite
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

phpMyAdmin Privileges Query

2010-07-04 Thread Michael Trewartha
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?

2010-07-04 Thread Michael Dykman
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

Why is Host option Failing?

2010-07-04 Thread Michael Satterwhite
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