NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
MySQL
7 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?
Getting mysql running on my NAS
Hi- i am trying to get mysql working on my NAS. I've looked at a number of posts on the forum, and have installed 'mysqlon' for my NAS, but this doesn't seem to have resulted in a working system. When I SSH and check the /etc/init.d/mysql status it is stated as not running. Starting results in an error. There is a mess of info on the forums in search, but they are all hitting old pages which no longer seem to work. Help please- how can i get mysql wokring on my NAS?679Views0likes1CommentHelp - 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
Using ReadyNAS 102 as MySQL with LibreOffice direct connector
Hello guys, I recently bought a ReadyNAS 102 and I'm was wondering if I could use it to store a MySQL database (the answer in yes), managing it with Libre Office Base (the answer is: I hope) I'm working with Xubuntu 14.04 and LibreOffice 4.2.8.2, I already installed phpMyAdmin on the NAS and, on my PC, the extension MySQL Connector from here http://extensions.libreoffice.org/extension-center/mysql-native-connector in phpMyAdmin I created the database my_dbase, giving to the user guest all the privileges. My NAS has a static DNS like: 192.168.1.50. Then, I followed this guide: https://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0 The problems start since: Setting up database connection Name of the database: my_dbase Host: 192.168.1.50 (or localhost?) Port: 3306 Socket: no idea if I have to use it and how... I try to connect as guest, with the guestpassword I choose and the result is: Can't connect to MySQL at 192.168.1.50 (111) If I use port 7082, the same as for php, the answer takes mor time and it's: lost connection to MySQL server at 'reading initial communication packet', system error:0 Any idea how to set it in a proper way? Thank you very much! Daniele