Re: Dropped table. . . Help Please

2005-12-14 Thread Johannes Franken
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 archives: http://lists.mysql.com/mysql

Re: display

2004-04-24 Thread Johannes Franken
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. -- Johannes Franken MySQL Certified Professional mailto:[EMAIL PROTECTED] http

Re: issue with my.cfg

2004-02-07 Thread Johannes Franken
? ^^ 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_INTERACTIVE flag. -- Johannes Franken MySQL

Re: MySQL listen on one IP only

2004-01-23 Thread Johannes Franken
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. -- Johannes Franken MySQL Professional mailto:[EMAIL

Re: Certification Test Questions

2004-01-19 Thread Johannes Franken
, 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.com/mysql To unsubscribe:http

Re: Certification Test Questions

2004-01-18 Thread Johannes Franken
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

2004-01-10 Thread Johannes Franken
'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 archives: http://lists.mysql.com/mysql

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

2003-12-22 Thread Johannes Franken
, 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.mysql.com/[EMAIL PROTECTED]

Re: % vs localhost in user.host

2003-12-22 Thread Johannes Franken
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: ? about user and db table

2003-12-19 Thread Johannes Franken
... -- 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

2003-12-18 Thread Johannes Franken
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. -- Johannes Franken MySQL Professional mailto