NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
MySQL
5 Topics
mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
I cannot set up a database in mysql using phpmyadmin. Both apps are installed on the NAS. Occarding to the documentation a configuration file in mysql needs to be installed. But there's no directory I can read to (re)place the config file.Appaently I need Debian to read and write mysql files. My local computer works with windows10. Question is: how to (re)place the config file in mysql?
Help - trying to get the MySQLOn Add-on to work / Mysql
Hi, i have a readynas Ultra 2 / RNDU2000. I am trying to get mysql to work properly. >/etc/init.d/mysql status shows stopped. When i install Mysqlon - https://community.netgear.com/t5/Using-your-ReadyNAS/MYSQLON/m-p/653674#M104194 It doesn't seem to make any difference. It could be i don't have quite the right add-on for my device, but i can't seem to find other version in forum search. Please help!ReadyNAS 214 on 6.7.4 - MySQL app failed to start
Yesterday I updated the firmware on my ReadyNAS 214 to 6.7.4. Once installed, the MySQL app stopped functioning. I rely on that for my web-based business management software that I wrote. Here's where I started: 1) Tried starting the app from the web interface. Got an error "Aplication failed to initialize" with "Code: 22002010000" 2) Tried without success both a reboot, and a shutdown and restart. 3) Tried uninstalling MySQL, PHPMyAdmin and reinstalling - same result. 4) Checked file permissions for the /var/lib/mysql database directory - all say mysql 5) Checked file permissions for the /etc/mysql directory - all say root 6) Tried to check the status from command line with this result: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Here's what fixed it: 1) So I made sure the processes were killed, ( sudo pkill mysqld; sudo pkill mysql ) 2) removed the app from the web interface 3) purged it from the command line ( sudo apt-get remove --purge mysql\* ) 4) Reinstalled the MySQL and PHP MyAdmin from the web interface 5) Everything worked again!! And my databases and MySQL users/permissions stayed intact. Yeah! Don't know if that helps anyone else, but it did for me.2.8KViews0likes2Comments
How do do you modify bind-address in my.cnf without SSH ?
How do I modify the my.cnf file and specifically the property “bind-address = 0.0.0.0 “in order allow connections to MySQL from another PC, without having to SSH into the box and edit the file using vi? The reason is that I am still under warranty and have been told that enabling SSH voids my readynas warranty so would ideally like to do this without putty or SSH ideally through PHPMyAdmin ?3.5KViews0likes3Comments