Member Avatar for riahc3

Hey

Im trying to start from scratch a MySQL installation in Linux but for some reason through apt-get and the software center, when I remove it, my users (and privileges) still exist. How can I remove everything releated to MySQL and start from 0?

Thank you

  • 2 Contributors
  • 5 Replies
  • 424 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by riahc3
Member Avatar for smantscheff

Look for the value of datadir in /etc/mysql/my.cnf or /etc/my.cnf, respectively. Usually it's /var/lib/mysql.
Unintall mysql with apt-get.
Delete this data directory with all subdirectories.
Delete all in /etc/mysql and /etc/my.ini, /etc/my.cnf etc.
Re-install mysql.

Member Avatar for riahc3

Look for the value of datadir in /etc/mysql/my.cnf or /etc/my.cnf, respectively. Usually it's > /var/lib/mysql.
Unintall mysql with apt-get.
Delete this data directory with all subdirectories.
Delete all in /etc/mysql and /etc/my.ini, /etc/my.cnf etc.
Re-install mysql.

Ill try this tommorow at work. Its really getting annoying...

Thanks :)

Edited by mike_2000_17 because: Fixed formatting
Member Avatar for riahc3

Did not work. /etc/my.ini, /etc/my.cnf did not exist.

Member Avatar for riahc3

Now this:

120411 8:47:23 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)
120411 8:47:23 [ERROR] Aborting

120411 8:47:23 InnoDB: Starting shutdown...
120411 8:47:24 InnoDB: Shutdown completed; log sequence number 1595675
120411 8:47:24 [Note] /usr/sbin/mysqld: Shutdown complete

start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error al procesar mysql-server-5.5 (--configure):
el subproceso instalado el script post-installation devolvió el código de salida de error 1
dpkg: problemas de dependencias impiden la configuración de mysql-server:
mysql-server depende de mysql-server-5.5; sin embargo:
El paquete `mysql-server-5.5' no está configurado todavía.
dpkg: error al procesar mysql-server (--configure):
problemas de dependencias - se deja sin configurar
No se escribió un informe «apport» porque el mensaje de error indica que es un mensaje de error asociado a un fallo previo.
Se encontraron errores al procesar:
mysql-server-5.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.