Difference between revisions of "MySQL"
From Alessandro's Wiki
Porcelinux (talk | contribs) |
(No difference)
|
Revision as of 08:03, 17 October 2006
Problemi
- Un bel giorno ho avuto un problema...
- errori in /var/log/messages:
061013 18:14:58 [ERROR] Can t start server : Bind on unix socket: Permission denied 061013 18:14:58 [ERROR] Do you already have another mysqld server running on socket: //var/run/mysqld/mysqld7415.sock ? 061013 18:14:58 [ERROR] Aborting
- si risolve con
chown -R mysql:mysql /var/lib/mysql chown -R mysql:mysql /var/run/mysql
SQL
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON [object_type] {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER 'cipher' [AND]]
[ISSUER 'issuer' [AND]]
[SUBJECT 'subject']]
[WITH with_option [with_option] ...]
