How do I check if MySQL is working?
Posted: 21. May 2007 23:12
I'm still learning how to use WAMP in a course. So I don't really know what needs to be done the LAMP way? Since XAMPP is kind of set in stone regarding certain behaviours I know even less what to do in order to make it work in Linux?
In the course I just follow instructions how to install MySQL then the part where you test the Database with Windows CMD you're supposed to check these things.
To see if the server is running.
To print out the version number for MySQL server.
To check how long the server has been online.
None of those simple commands seem to work with XAMPP on Linux
What am I doing wrong?
The password is supposed to be empty it says on the webpage but still it won't work?
In the course I just follow instructions how to install MySQL then the part where you test the Database with Windows CMD you're supposed to check these things.
To see if the server is running.
- Code: Select all
c:\> mysqladmin -u root -p ping
To print out the version number for MySQL server.
- Code: Select all
c:\> mysqladmin -u root -p version
To check how long the server has been online.
- Code: Select all
c:\> mysqladmin -u root -p status
None of those simple commands seem to work with XAMPP on Linux
- Code: Select all
mike@sanka:~$ mysqladmin -u root -p ping
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
mike@sanka:~$
What am I doing wrong?
The password is supposed to be empty it says on the webpage but still it won't work?