Rich Deeming wrote:
> DB dir owned by mysql not daemon...
>
> [root@r1 ~]# ls -al /var/lib/mysql
> total 28
> drwxr-xr-x 5 mysql mysql 4096 Jan 18 04:41 .
> drwxr-xr-x 38 root root 4096 Jan 9 19:42 ..
> drwx------ 2 mysql mysql 4096 Nov 27 10:44 mysql
> srwxrwxrwx 1 mysql mysql 0 Jan 18 04:41 mysql.sock
> drwx------ 2 mysql mysql 4096 Jan 10 10:53 mythconverg
> drwx------ 2 mysql mysql 4096 Nov 27 10:44 test
>
> Checking that SUSE starts mysql with the same args this is mine.
>
> root 2968 1 0 Jan18 ? 00:00:00 /bin/sh
> /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
> --pid-file=/var/run/mysqld/mysqld.pid
> mysql 2997 2968 0 Jan18 ? 00:00:00 /usr/libexec/mysqld
> --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql
> --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
>
>
amd64:/home/tdec # mysqlaccess -d info
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- + --------------------
N N N N N N N N N N N N N N N N N N N N N ? ? ? ? 0 0 0 | localhost,nobody,info
amd64:/home/tdec # mysqlaccess -d mythconverg
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- + --------------------
N N N N N N N N N N N N N N N N N N N N N ? ? ? ? 0 0 0 | localhost,nobody,mythconverg
amd64:/home/tdec # mysqlaccess -d test
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- + --------------------
Y Y Y Y Y Y N N N N N Y Y Y N N Y Y N N N ? ? ? ? 0 0 0 | localhost,nobody,test
amd64:/home/tdec # mysqlaccess -d mysql
Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB
---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- + --------------------
N N N N N N N N N N N N N N N N N N N N N ? ? ? ? 0 0 0 | localhost,nobody,mysql
Rich,
Sorry I have to bug you again. You were correct in your message about my problems with the mytyfilldatabase.
I'm trying to determine if my permissions are corrrect as well as the parameter to start the server.
I am new to linux and mysql. Mythtv has my introduction to this new enviroment so many obvious things are not
obvious for me :-(.
Above are all the databases I have in mysql.
Do you see any problems?
Should I change the User in the mythconverg to mythtv?
TIA.
Initially I though the hardest part was going to be the module vide/sound and I was wrong.
Everything was easy until I start to deal with mysql. Well I will go step by step until
the whole thing is solved.
Best regards,
-=terry(Denver)=-
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
