Difference between revisions of "Command line cheat sheet"
old>Admin |
m (21 revisions imported) |
||
| (2 intermediate revisions by one other user not shown) | |||
| 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 | ||
| Line 45: | Line 45: | ||
</blockquote> | </blockquote> | ||
Edit connection string | Edit connection string | ||
<blockquote> | <blockquote> | ||
Latest revision as of 11:51, 10 December 2021
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