Re: Dropped table. . . Help Please

. Under Linux you can use tools like e2undel and debugfs and certain versions of mc. Please let us know, if you need help with these tools. Good luck! -- Johannes Franken MySQL Certified Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archive

Re: display

llows you to use the four cursor keys for scrolling though the results. Another idea would be typing "\G" instead of ";" at the end of each statement, which prints the columns as lines. Type "help" at the mysql prompt to learn more about these internal commands.

Re: issue with my.cfg

#x27;t it be "/etc/my.cnf" ? ^^ Did you place the wait_timeout parameter in the [mysqld] section? 2.) Have you tried setting interactive_timeout instead? See http://www.mysql.com/doc/en/mysql_real_connect.html for an explanation of the CLIENT_INTE

Re: MySQL listen on one IP only

on multiple (but not all) interfaces. Maybe it's a solution to bind mysqld to localhost, forward a low port (that is: port number <1024) of the YOURIPADDRESS interface to it and let your clients connect to that low port. This would at least require the horse to have root privileges. -- Johann

Re: Certification Test Questions

ve" and "all of the above", which makes things much harder when you are not sure or running out of time. -- Johannes Franken Professional unix/network development mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Certification Test Questions

. BTW, I sent a long list of corrections to that xml guy; if he's put them in, the test should be fine now. > 3. What version is the test geared for? It's about version 4. -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't connect to MySQL server

bian. Remove the line 'skip-networking' from /etc/mysql/my.cnf, type "/etc/init.d/mysql restart" and try connecting to the IP address again. -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list arch

Re: % vs localhost in user.host

verification, please send me the output of 'select Host,User,Password from mysql.user;' . -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Deleted all users from MYSQL. What to do now?

For details, please refer to http://www.mysql.com/doc/en/Resetting_permissions.html -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

Re: ? about user and db table

t. BTW, after fiddling with the "mysql"-database, don't forget to "FLUSH PRIVILEGES" or "mysqladmin reload"... -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: localhost

nd more secure than the tcp connection it chooses for non-localhost servers. If you really still want to connect to the hostname, you should - make sure there is no "skip-networking" in my.cnf, - grant access to [EMAIL PROTECTED] and - run "mysql -u SOMEUSERNAME -p -h servername.foo.org&qu