quinta-feira, 13 de março de 2014

[RASCUNHO] Cola (cheatsheet) para problemas na instalação de MySQL no Ubuntu


Purge
sudo apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5 mysql-server-5.5 sudo apt-get purge mariadb-server-5.5
sudo apt-get purge mariadb

Remove

sudo rm -rf mysql.dpkg-bak
sudo apt-get remove mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo rm -rf /var/lib/mysql
sudo deluser mysql

Install

sudo apt-get install mysql-server-core-5.5
sudo apt-get install -f mysql-server (-fix)
sudo apt-get install -f libaio1
 

Install from deb pack

sudo dpkg -i mysql-5.6.13-debian6.0-i686.deb

Logs/status

service mysql status
ps ax | grep mysql
grep mysql /var/log/syslog
grep mysql /var/log/daemon.log
sudo netstat -tap | grep mysql
sudo service mysql restart
mysql –version
which mysql

DPKG

sudo dpkg --configure -a
sudo rm /var/lib/dpkg/lock
sudo rm /var/cache/apt/archives/lock
sudo dpkg -S etc/mysql

Check


sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo deluser mysql
sudo rm -rf /var/lib/mysql


Connection URL



jdbc:mysql://localhost:3306/test







Reference

https://rtcamp.com/tutorials/mysql/mysql-5-6-ubuntu-12-04/

Nenhum comentário: