How can I retrieve the table 'mysql.host' ?
I am working with MySQL on a Windows NT machine. I use Innodb tables. I, usually, switch on MySQL with: mysqld-max --standalone But now, I try this, MySQL crash, and I got the message: mysqld-max: Table 'mysql.host' doesn't exist in the 'mysql.err' file. I have found that I start up MySQL with: mysqld-max -Sg --standalone, then it works. Please, how can I rebuild the 'mysql.host' table to all is OK again? Thanks in advance José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: How can I retrieve the table 'mysql.host' ?
José, Tuesday, September 24, 2002, 10:30:30 AM, you wrote: JF I am working with MySQL on a Windows NT machine. I use JF Innodb tables. I, usually, switch on MySQL with: JF mysqld-max --standalone JF But now, I try this, MySQL crash, and I got the JF message: JF mysqld-max: Table 'mysql.host' doesn't exist JF in the 'mysql.err' file. JF I have found that I start up MySQL with: mysqld-max JF -Sg --standalone, then it works. JF Please, how can I rebuild the 'mysql.host' table to JF all is OK again? Does host table exist? or MySQL server doesn't see privilege tables? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: How can I retrieve the table 'mysql.host' ?
Please, can you give me more information about this? I think that in Windows NT the privilege tables are built during installation I think that I have not changed anythink. How can I find if there are problems to MySQL see the privilege tables? Many Thanks. José --- Egor Egorov [EMAIL PROTECTED] escribió: José, Tuesday, September 24, 2002, 10:30:30 AM, you wrote: JF I am working with MySQL on a Windows NT machine. I use JF Innodb tables. I, usually, switch on MySQL with: JF mysqld-max --standalone JF But now, I try this, MySQL crash, and I got the JF message: JF mysqld-max: Table 'mysql.host' doesn't exist JF in the 'mysql.err' file. JF I have found that I start up MySQL with: mysqld-max JF -Sg --standalone, then it works. JF Please, how can I rebuild the 'mysql.host' table to JF all is OK again? Does host table exist? or MySQL server doesn't see privilege tables? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: re: How can I retrieve the table 'mysql.host' ?
José, Tuesday, September 24, 2002, 4:29:05 PM, you wrote: JF I think that in Windows NT the privilege tables are JF built during installation Correct. JF I think that I have not JF changed anythink. How can I find if there are problems JF to MySQL see the privilege tables? Check if files host.frm, host.MYD, host.MYI exist in the 'mysql' database dir. If so, you wrote that you use my.cnf file, right? Have you specified path to the data dir there? Show me the contents of the my.cnf. JF --- Egor Egorov [EMAIL PROTECTED] escribió: JF José, Tuesday, September 24, 2002, 10:30:30 AM, you wrote: JF I am working with MySQL on a Windows NT machine. I use JF Innodb tables. I, usually, switch on MySQL with: JF mysqld-max --standalone JF But now, I try this, MySQL crash, and I got the JF message: JF mysqld-max: Table 'mysql.host' doesn't exist JF in the 'mysql.err' file. JF I have found that I start up MySQL with: mysqld-max JF -Sg --standalone, then it works. JF Please, how can I rebuild the 'mysql.host' table to JF all is OK again? Does host table exist? or MySQL server doesn't see privilege tables? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php