I am using debian linux.
I have a linux machine on which mysql is install.
I can log in to my linux machine using root user as well as other user.
I can connect to mysql database on linux machine from windows machine using sqlyog.
Now I want to execute queries on linux machine only using linux terminal
I tried some following things on terminal
I went to root directory then I went to /var/lib directory
I run following commands on terminal
mysqladmin -u root -p
mysqladmin -u root -ppassword
everytime I have get following error message
ERROR 1045 (28000) Access denied for
user 'root'@'localhost' (Using
password NO)
please guide me for following
How do I get mysql prompt in linux terminal?
How I stop the mysql server from linux terminal?
How I start the mysql server from linux terminal?
How do I get mysql prompt in linux terminal?
How do I login to mysql server from linux terminal?
How do I solve following error?
ERROR 1045 (28000) Access denied for
user 'root'@'localhost' (Using
password NO)
Please give me solutions for above question.
Thank You
解决方案
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.