Difference between revisions of "Command line cheat sheet"
old>Admin |
old>Admin |
||
| Line 29: | Line 29: | ||
<blockquote> | <blockquote> | ||
mysql -uroot -pPW1234 | mysql -uroot -pPW1234 | ||
* GRANT SELECT ON *.* TO 'remoteuser' | * GRANT SELECT ON *.* TO 'remoteuser'@'195.67.11.34' IDENTIFIED BY 'PW1234'; | ||
* FLUSH PRIVILEGES; | * FLUSH PRIVILEGES; | ||
* exit | * exit | ||
Revision as of 10:46, 22 February 2013
MySQL commands
Import and export
Import data from a SQL dump file to a specific database:
mysql -uroot -pPW1234 --default_character_set utf8 tslive < dumpLive.sql
Export data to SQL dump file from selected databases
mysql -uroot -pPW1234 --databases tslive tstest tsbase > dump.sql
Export ALL data to SQL dump file
mysql -uroot -pPW1234 --all-databases > dump.sql
Service control [LINUX]
Start/stop server
sudo service mysqld start
sudo service mysqld stop
User management
Add extra user with readonly access to all databases
mysql -uroot -pPW1234
- GRANT SELECT ON *.* TO 'remoteuser'@'195.67.11.34' IDENTIFIED BY 'PW1234';
- FLUSH PRIVILEGES;
- exit
Tomcat commands [LINUX]
Start/stop server
sudo /etc/init.d/tomcat6 stop
sudo /etc/init.d/tomcat6 start
List running applications
ls -l /usr/share/tomcat/webapps/*.war
Edit connection string
sudo nano /usr/share/tomcat/conf/Catalina/localhost/TempusServa.xml
Edit server settings
sudo nano /usr/share/tomcat/conf/server.xml