home       inleiding       sysadmin       services       links       bash       werk       nothing      

een oplossing voor S.C.

student@ub12-04-exa2-11:~$ history | grep sql

   80  sudo apt-get install mysql-server php5-mysql
  103  mysql -u root -p
  118  sudo apt-get install php5-mysql
  216  sudo apt-get install apache2 php5 php5-mysql
  225  sudo apt-get purge php5-mysql
  229  sudo apt-get install apache2 php5 php5-mysql
  236  sudo apt-get remove php5-mysql*
  237  sudo apt-get remove mysql-server*
  242  sudo apt-get install apache2 php5 php5-mysql
  246  mysql -u root -p mysql
  247  mysql -u root -p 
  249  sudo mysql -u root -p
  250  mysql -u root -p
  251  sudo service mysql start
  252  sudo service mysql restart

een heleboel mysql operaties ...
we proberen in te loggen:

$ mysql -u root -p mysql
Enter password:  x-x-x-x
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

inloggen lukt niet, dus doen we ...

$ sudo apt-get remove mysql-server
0 upgraded, 0 newly installed, 0 to remove and 156 not upgraded.

hij verwijdert eigenlijk niets ...
dus dan doen we het op de volgende manier:

$ sudo apt-get purge mysql-server
0 upgraded, 0 newly installed, 1 to remove and 156 not upgraded.
After this operation, 0 B of additional disk space will be used.
Do you want to continue [Y/n]? y
(Reading database ... 52144 files and directories currently installed.)
Removing mysql-server-5.5 ...
Purging configuration files for mysql-server-5.5 ...
Processing triggers for ureadahead ...

Opnieuw installeren:
 
$ sudo apt-get install mysql-server
 
inloggen en dbase creëren:
 
$ mysql -u root -p mysql
 
... en wordpress installeren via lynx wordt 'kinderspel'.