2012-04-06, 23:57
(2012-04-06, 22:07)Finchy Wrote: ...for example, when I try
mysqlcheck -op -u xbmc xbmc_video
in the command prompt on the WHS with MySQL Server installed I get a 1045 error.
mysqlcheck -uuser -ppassword --optimize xbmc_video
Try it without spaces between -u and user name, and no spaces between -p and password
From the MySQL man page
Quote:The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the
option and the password. If you omit the password value following the --password or -p option on the command line, mysqlcheck
prompts for one.
Specifying a password on the command line should be considered insecure. See Section 5.3.2.2, âEnd-User Guidelines for Password
Security
For other users struggling with permissions maybe an idea is to begin with granting all permissions both within MySQL as well as SMB for the folder access, and then one by one take permissions away, that way you can narrow down where you are running into an issue