October 2nd, 2013, 02:43 PM
How to set command prompt to automatically cd into Mysql dir
I know this is really a n00b question i just started using mysql. How do i make it easier for me to cd into my mysql directory without having to go an copy and paste into command prompt.
October 2nd, 2013, 03:03 PM
Less a MySQL question, more about your command line/terminal.
What OS and what are you trying to do in the mysql directory?
October 2nd, 2013, 03:16 PM
windows 8 command prompt latest version of mysql
Originally Posted by requinix
Whenever i work in mysql i have to cd into this dir.
C:\Program Files\MySQL\MySQL Server 5.6\bin
soo.. i dont know why your asking me what i need to do. when anytime you use mysql your suppose to login and use this command
Mysql -uroot -proot
October 2nd, 2013, 03:24 PM
Don't connect as root unless you need to create databases or manage users.
1. WinKey + I, PC Info
2. Advanced System Settings on the left
3. Environment Variables (button in the Advanced tab)
4. Create a new user variable named "PATH" with the value "%PATH%;C:\Program Files\MySQL\MySQL Server 5.6\bin". If there's one already there then add to it everything from the semicolon on.
5. Close all the windows and your command prompts.
6. Start a new prompt and try just "mysql -uroot -proot" - without changing directories.
October 2nd, 2013, 08:16 PM
You can also do the following:
1. Type CMD (Windows search should find the command prompt command).
2. Right click on CMD and select properties
3. In the Shortcut tab select "Start In" and adjust it to the value you want.
October 12th, 2013, 01:40 PM
just wanted to thank you all for everything!