I was able to mount Windows 2000 server shared folder with RH 7.1 by the following command # mount –t smbfs –o username=mysql,password=xxx //server1/mydata /var/lib/mysql/nt mydata is the shared folder on W2K server. I can see files that originally stored in my shared folder ‘mydata’ by doing # ls –l /var/lib/mysql/nt My have modified /dev/my.cnf [mysqld] Datadir=/var/lib/mysql/nt [mysql.server] user=mysql I also did the following steps on MySQL # mysql_install_db # /usr/bin/safe_mysqld start mysql>insert into host (host,db,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) values('localhost',’%’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’); mysql> insert into user(host,user,password) values(‘localhost’,’mysql’,password(‘mypasswd’)); mysql>insert into db (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) values( 'localhost','nt','mysql,'Y','Y','Y','Y','Y','Y'); I have two questions: 1. The owner and group of my database directory at var/lib/mysql/nt showing root root, even I changed it to mysql mysql before starting samba. How to change the owner and group of those files to mysql? 2. I got “ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: NO)” everytime when I want to use # mysql –u root 3. I also had the error of “/usr/libexec/mysqld: Too many parameters” in the /var/log/mysqld.log file. How to solve this problem? Please help me! Please tell me how to integrating Samba with MySQL!

You have to specify the UID=mysql in mount. You may have more possibilities with smbmount instead of mount. EX: smbmount //server1/mydata /var/lib/mysql/nt -o username=mysql%password,uid=mysql

try : chmod mysql file_name chgrp mysql file_name