MySql Interview Questions
 
Q: How do you start and stop MySQL on Windows?
Ans : net start MySQL, net stop MySQL
Date submitted :8/8/2009 1:03:38 AM
Submitted by : shabir@myfaithsolution.com
Q: How do you start MySQL on Linux?
Ans : /etc/init.d/mysql start
Date submitted :8/8/2009 1:03:38 AM
Submitted by : shabir@myfaithsolution.com
Q: Explain the difference between mysql and mysqli interfaces in PHP?
Ans : mysqli is the object-oriented version of mysql library functions.
Date submitted :8/8/2009 1:03:38 AM
Submitted by : shabir@myfaithsolution.com
Q: What’s the default port for MySQL Server?
Ans : 3306
Date submitted :8/8/2009 1:03:38 AM
Submitted by : shabir@myfaithsolution.com
Q: What does tee command do in MySQL?
Ans : tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by command notee.
Date submitted :8/8/2009 1:03:38 AM
Submitted by : shabir@myfaithsolution.com
Q: Can you save your connection settings to a conf file?
Ans : Yes, and name it ~/.my.conf. You might want to change the permissions on the file to 600, so that it’s not readable by others
Date submitted :8/8/2009 1:03:38 AM
Submitted by : shabir@myfaithsolution.com
1