Cello ricevo un errore nell’installare il db
[root@localhost luca]# mysql_install_db --user=mysql
Installing MySQL system tables...
130508 10:44:17 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
130508 10:44:17 [ERROR] Aborting
130508 10:44:17 [Note]
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/libexec/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
[/code]
Ho controllato in quella cartella ci trovo questa roba:
[code] [root@localhost mysql]# ls
ibdata1 localhost.localdomain mysql
ib_logfile0 localhost.localdomain?"127.0.0.1?localhost.err performance_schema
ib_logfile1 localhost.localdomain.err test
Da notare quel file con un nome assurdo.
Flogger ho controllato tutti i file e le modifiche proposte ci sono già, tranne quella del servername in httpd.conf che ho aggiunto dopo ma non ha cambiato niente.
edit penso di aver capito il problema…
edit bis Si era creato un problema con httpd, dopo qualche modifica avevo impostato male il nome dell’host e quindi non partiva ma ora ho risolto. Comunque mysql continua a non partire anche se provo a installare da il db da root il processo va a buon termine
[root@localhost httpd]# mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
Il problema è che quando provo a settare la password mi da il solito problema:
[root@localhost httpd]# /usr/bin/mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)