tag:blogger.com,1999:blog-6166163134010074991.post2356941032496347604..comments2023-06-18T12:06:25.641+08:00Comments on Writings on the wall: Setting up MySQL on DNS-323Sidneyhttp://www.blogger.com/profile/10694218135056032669noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6166163134010074991.post-67580806485103049842011-10-05T23:45:03.512+08:002011-10-05T23:45:03.512+08:00on:
"# mysql -u root -p"
i get an erro...on:<br /><br />"# mysql -u root -p"<br /><br />i get an error 2002 (HY000): Cant connect...<br /><br />should i type a command :<br /><br />"sh mysql.sh start" ?<br /><br />thanks in advance.<br /><br />PARUSAAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6166163134010074991.post-7730362074905558812011-07-31T05:44:52.185+08:002011-07-31T05:44:52.185+08:00On DNS-320, the install script isn't complete....On DNS-320, the install script isn't complete. You must first create the mysql user, and THEN run the install script :<br /><br />useradd -U -s /bin/false mysql<br />funpkg -i mysql-5.0.67-2.tgz<br /><br />And, once the install is over, the init script must be made executable so mysql is launched automatically at boot time of the NAS :<br /><br />chmod a+x /ffp/start/mysqld.shAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6166163134010074991.post-21282955884494324012009-10-11T19:50:52.310+08:002009-10-11T19:50:52.310+08:00Also, the following error:
root@dlink-XXXX:/mnt/HD...Also, the following error:<br />root@dlink-XXXX:/mnt/HD_a2/ffp/var/mysql# mysql -u root -p<br />Enter password:<br />ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)<br /><br /><br />means password wasn't set for root user<br />/ffp/bin/mysqladmin -u root password 'passcomeshere'<br /><br />This is probably a mysql standard routine, but since I, and probably others might not be mysql admins, can be a showstopper.<br /><br />CheersYnoreply@blogger.comtag:blogger.com,1999:blog-6166163134010074991.post-87756041160815273852009-10-11T19:37:04.568+08:002009-10-11T19:37:04.568+08:00What about creating and setting up a mysql user (a...What about creating and setting up a mysql user (and changing ownership of mysql directories: <br />chown -R mysql /ffp/var/run/mysql<br />chown -R mysql /ffp/var/mysql<br /><br />Is it required? Did I need to do it to start mysql running?<br /><br />Thanks<br /><br />YYnoreply@blogger.com