With this I mean that you have a VPN server running at your home. I would never open port 3306 like that, since it is a well known port and attackers/malicious people may easily find access to your database.Īnother option is using a VPN connection to connect to your home. This is usually done in your modem or router, where you can set port forwarding. your public IP address), you’d have to open port 3306 in your firewall. Having said that, if you’d connect straight to home (through the IP address of your Internet connection – a.k.a.
So for that you may have to contact QNAP support. Good to hear! Glad you’ve got it to work.Īs for access from the Internet … ehm … I do not use, and I do not know it they support traffic through port 3306 or how they even redirect your data to your home. I never had to tinker with it, as the setup already did it correctly. This may be a little too open for security reasons, but can be refined to a specific IP address or IP address range.įor testing, start with setting “Host name” to “%” for that user (if this is at home, then this is probably not a security concern).Īs far as I can see on my system, there is only “” in the phpMyAdmin directory on my QNAP. When looking in phpMyAdmin, under “ User account“, you can see a column “ Host name“, make sure this is set to “ %” (meaning: originating from anywhere in the network). Default this should not be blocked, unless you specifically did set this.ģ) You’ll also have to make sur that the user you’re using to login, has access rights in the database which allows for a user to connect from another computer. Since it says “pre-login”, I assume this can be caused by a few things ġ) Make sure that you add the right port number ( 3306 is the default port number, eg. Unfortunately, I’m unable to walk through this right now, since my QNAP is on a boat on it’s way to Europe Reply
#Access phpmyadmin password#
The user “root” with password “myPass” should have access to all the databases – in PHPMyAdmin you’ll find an option “Privileges” where you can create (another) user called “root” with password “myPass” that has access to everything (access from 127.0.0.1, for all tables that are needed, if unsure start with setting access to everything for testing). And upon looking for the database ‘file’ created I can’t seem to find it.įirst off, the actual “database” is stored in a file on your QNAP, and you’ll have to either find the my.ini file to determine the path or look in the shares (start with However, you would not necessarily need the location of the database file for what you’re trying to do.Īssuming the PHP script is stored on the QNAP, th following should theoretically work: \n” From my ignorance this may be a php question but I am guessing that the database created in PhpMyAdmin is not being properly located or directed to. My php calls for:Īlways returning ‘Unable to Connect to ….’ No matter what I use. Thus using example: //192.168.1.100/database/index.php to connect and access content.
There is nothing I can find in the /web/phpmyadmin folder that refers to my created database.Įssentially I want to create the initial database through PhpMyAdmin and then allow intranet users through a web interface to modify, visualize and print. However I have no idea where PhpMyAdmin saves the database on the Qnap. I can create a database without any problems. PhpMyAdmin is installed and running on the Qnap with everything working fine there.
#Access phpmyadmin free#
Hope this is helpful, feel free to ask if you have more questions or in case this was not answering your question Reply I do not have my QNAP handy right now (in the middle of a move from the US to Europe), but I did find a post in the QNAP forum mentioning: “MDO0_DATA” may be different depending on your QNAP hardware and QTS version. Sometimes we need to add this to a user account to allow access. For example %.%.%.% means from any computer, or 192.168.1.% from any computer in the 192.168.1.xxx range. MySQL does set the allowed connection with each user. If you try the IP address of the QNAP or the network name In this case 127.0.0.1 and localhost will not work. – Or is this from another device (not the QNAP) for example through KODI?
#Access phpmyadmin manual#
If you did a manual install, you’ll have to tinker with the config file (which I would not recommend).
– Is this in PHPMyAdmin (running on the QNAP)?ĭefault PHPMyAdmin (if installed through the QNAP web interface) should work straight out of the box.
0 kommentar(er)
