New Developer Posted March 5, 2014 Share Posted March 5, 2014 i am new to php and mysql, and really enjoying your book. thank you! one quick question: i was able to successfully access mysql through the command line yet i am having trouble with the -u and -p arguments: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corrosponds to your MySQL server version forthe right syntax to use near '-u root -p' at line 1 mysql> i am running version 5.6.16 where can i look to find the correct syntax? (i poked around online for a bit but wasn't succesful) thanks again for the great book! Link to comment Share on other sites More sharing options...
HartleySan Posted March 5, 2014 Share Posted March 5, 2014 Hello and welcome to the forums. This help: http://dev.mysql.com/doc/refman/5.1/en/connecting-disconnecting.html Link to comment Share on other sites More sharing options...
New Developer Posted March 5, 2014 Author Share Posted March 5, 2014 Thank you for the link!i actually tried that earlier, that syntax exactly, and the error message keeps popping up . Link to comment Share on other sites More sharing options...
New Developer Posted March 5, 2014 Author Share Posted March 5, 2014 i found a way to make it work. here is the link: http://www.elated.com/articles/mysql-for-absolute-beginners/ cd c:\xampp\mysql\bin and press Enter, then type mysql -u root and press Enter. Thanks again Link to comment Share on other sites More sharing options...
HartleySan Posted March 5, 2014 Share Posted March 5, 2014 So basically, you were in the wrong directory? Link to comment Share on other sites More sharing options...
Recommended Posts