1.- How do I get mysql prompt in linux terminal?
mysql -u root -p
At the Enter password: prompt, well, enter root’s password 🙂
You can find further reference by typing mysql --help or at the online manual.
2. How I stop the mysql server from linux terminal?
It depends. Red Hat based distros have the service command:
service mysqld stop
Other distros require to call the init script directly:
/etc/init.d/mysqld stop
3. How I start the mysql server from linux terminal?
Same as #2, but with start.
4. How do I get mysql prompt in linux terminal?
Same as #1.
5. How do I login to mysql server from linux terminal?
Same as #1.
6. How do I solve following error?
Same as #1.