| Author |
Terminal QOD for 12-10-03 Part II
|
|
| Papiya 2003-12-10, 7:56 am |
| A user trying to connect to your MySQL server tells you he/she cannot connect. What MySQL command would be most likely to fix this problem:
A. FLUSH PRIVILEGES;
B. GRANT SELECT TO user@localhost;
C. FLUSH HOSTS;
D. mysqldump | |
| Papiya 2003-12-11, 4:52 pm |
| quote:
Originally posted by Papiya
A user trying to connect to your MySQL server tells you he/she cannot connect. What MySQL command would be most likely to fix this problem:
A. FLUSH PRIVILEGES;
B. GRANT SELECT TO user@localhost;
C. FLUSH HOSTS;
D. mysqldump
No MySQL fans here apparently. The answer is C. | |
| Boulware5 2003-12-12, 12:36 am |
| I had no idea, LOL. I have never used MySQL. | |
| me? I dunno... 2003-12-12, 11:50 am |
| quote:
No MySQL fans here apparently
I am a fan of every contribution you make here, the same goes for Bouleware5, and of course all the other people who help out with whatever they can. | |
| I Hate Pascal 2003-12-12, 10:35 pm |
| MySQL will allow a certain host to query it. If too many requests come from that host to rapidly, mysqld will assume something has went awry with that host and will bar it from making further requests. The "flush hosts" command resets the host cache and allows the host to reconnect to the database server.
As for you cats who have never used MySQL, get a grip. It is a very simple, free database that is extremely fast, and is of especial use in web site development. It might be a good idea to get used to databases using MySQL before attempting Oracle or DB2. You'll memorise maybe 50 simple commands and you will have a backend that is highly useful in stpring data of all kinds and serving it up at lightning speed. | |
| ClintonN 2003-12-13, 1:00 am |
| I just got through a 5 day class on MS's SQL server my work paid for. Databases are not something I really want to learn about but I think it's a necessity. I guess it wouldn't hurt me to check out mysql. Thanks for the info you guys! | |
| ClintonN 2003-12-13, 1:09 am |
| Oh by the way if you want to try out IBM software for linux like db2. You can order it here
http://www-106.ibm.com/developerwor...1&S_CMP=sektile
I have to use Lotus Domino at work on Windows 2k So I've been playing around with it at home on linux. Just in case you guys want to check it out. |
|
|
|