jimmi8 Posted February 9, 2007 Share Posted February 9, 2007 hi, IM using the commanf line to do some sql stuff. I usually use phpmyadmin and i have a few questions about using the prompt. Once im in to the database i need to change the password. I understand i do it with this line: SET PASSWORD = OLD_PASSWORD('yournewpassword'); is that right? also how do i back up the database via the command line? Php my admin has a tool for this but i dont know how rto do it via the terminal. thanks Link to comment https://forums.phpfreaks.com/topic/37732-command-line-questions/ Share on other sites More sharing options...
jimmi8 Posted February 9, 2007 Author Share Posted February 9, 2007 right sorry to bore anyone with this but when i try conecting to the db using this (on on the mysql command line by the way so ive got this mysql> already !) -u ausername -h https://adomain.com -p; im typing exactly that but i cannot get in. it gives me a 1064 error: you have an error in your mysql syntax. why?!?!?? Link to comment https://forums.phpfreaks.com/topic/37732-command-line-questions/#findComment-180534 Share on other sites More sharing options...
JasonLewis Posted February 9, 2007 Share Posted February 9, 2007 have you searched google or somewhere. because i dont really have any idea about command line with this. Link to comment https://forums.phpfreaks.com/topic/37732-command-line-questions/#findComment-180564 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.