phpMyAdmin (3.4.10.1)

[WhoCares_]

phpMyAdmin 3.4.10.1

• Description:
  

  phpMyAdminis a software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

• Requirements: RAIDiator 4.2.15 or newer

• Platform: Intel

• Current Version: PHPMyAdmin 3.4.10.1 v1.3.2
  
  • Changes from previous release:
    - Updated PhpMyAdmin to 3.4.8
    - New: Access level configuration from within Frontview

• Important:
  
  
  
• This add-on requires that a PHP add-on is installed first. (it will check on install)
• 
  
  

• Access Configuration:
  To prevent any unauthorized access to PhpMyAdmin and the databases it connects to, you can set different access levels from the add-on's management window. After installation the add-on is by default accessible by everyone. So do yourself a favor and set the access levels.
  
  
  
  • As you can see, there are two different groups of access levels: One for accessing the PhpMyAdmin web application, the other for accessing PhpMyadmin's setup where you define the servers users should have access to. Initially both grous are set to "Open", meaning everyone on your network can access everything:
    
  
  
  • Access levels for the "Setup" group can be set independently from the "Access" group. So as shown in the example below you can make the PhpMyAdmin application available to everyone, while the Setup is only accessible by the admin user of your ReadyNAS.
    
  
  
  • Access levels for the "Access" group however directly influence the settings for the "Setup" group. You cannot have a Seup that is more open than the access level of the "Access" group. For example in the screenshot below, "Access" was set to "Admin only" and since it doesn't make much sense to restrict access to the admin but have everyone access the setup, the permission level for the "Setup" group was changed to "Admin only" automatically. Likewise, if you chose "Users only" for the Access group, the Setup group has to be set to "Users only" or "Admin only". Note that as you can see in the screenshot options currently unavailable will not be selectable.
    
  
  
  
  

• Configuration:
  After installing the add-on, you get two options on the "Installed Add-ons" screen: Use PhpMyAdmin and Configure PhpMyAdmin. Since PhpMyAdmin can be used to manage local and remote MySQL servers, you have to configure it before you can actually use it.
  
  
  
  Once you click on the Configure PhpMyAdmin link you are taken to a new browser windows that displays PhpMyAdmin's integrated web setup. There may be some warning messages shown at this point which you can safely ignore.
  
  
  
  To add a new server click on the New Server button located in the middle of the screen.
  You are then presented with a tabbed viwe of multiple settings pages. Don't worry, you don't need to fill in each and every detail. The most important fields are Verbose name of this server which should contain a description that allows you to identify the server easily. Also important is the Server hostname field. Here you either enter the IP address of the MySQL server you want to manage or a fully qualified hostnamed to that server that can be resolved using DNS.
  
  
  
  Once you click the Save button at the bottom of the input form your changes you are directed back to the overview. Do not forget to klick the Save button there, too. Otherwise all your configuration is lost once you close that window.
  When your settings are saved you can start using PhpMyAdmin on your ReadyNAS to manage your MySQL servers.
  
  
  
  

• History
  
  • PHPMyAdmin 3.4.10.1 v1.3.2
    - New PhpMyAdmin release
  
  
  • PHPMyAdmin 3.4.8 v1.2.9
    - New PhpMyAdmin release
    - Access level configuration
  
  
  • PHPMyAdmin 3.4.4 v1.2.7
    - New PhpMyAdmin release
  
  
  • PHPMyAdmin 3.4.3.2 v1.2.6
    - New PhpMyAdmin release
  
  
  • PHPMyAdmin 3.4.3.1 v1.2.4
    - New PhpMyAdmin release
  
  
  • PHPMyAdmin 3.4.2 v1.2.1
    - Initial release

[WhoCares_]

Updated to: PHPMyAdmin 3.4.3.1 v1.2.4

- New PhpMyAdmin release

[WhoCares_]

Updated to: PHPMyAdmin 3.4.4 v1.2.7

- New PhpMyAdmin release

[WhoCares_]

Updated to: PHPMyAdmin 3.4.8 v1.2.9

- New PhpMyAdmin release
- Allows setting of different access levels for PhpMyAdmin setup and general access to PhpMyAdmin

[WhoCares_]

Updated to: PHPMyAdmin 3.4.10.1 v1.3.2

- New PhpMyAdmin release

[Thunderoid]

Hey!

Thanks for supplying all these addons to expand the capabilities of the ReadyNAS 🙂

Will this addon also require the mySQLon addon (can't find x86 version available anymore..?) or the ReadyNAS Photos II to be active, or is there some other better way to activate MySQL? (Readynas Ultra 4, RAIDiator 4.2.27)

I recently did a factory reset on my Ultra 4 which was running owncloud 6 (PHP 5.4.45 and Owncloud6 bought from your site), but just for my personal use.

Intend to extend to more family members and wanted to start from scratch for most updated version and dedicated to Owncloud..

So bought owncloud 8 install, and found it recommends MySQL for more than one user - so also got this phpMyAdmin installer.

From factory reset added these: SSH enable, php, PHPMyAdmin, owncloud.

Found that there are no files under /var/run/mysqld - no mysqld.sock

Neither tcp or socket will let me connect, or switching between cookie and config authentication. Saved after applying each time.

Should I choose to use SSL (will the readynas support it?)

The error messages at "https://192.168.1.105/phpmyadmin/index.php" are either;
- config authentication: any user/pass combination results in: "#2002 Can not login to the MySQL server"

- cookie authentication or socket connection: before any login "Can not connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You must check the host (host), username (username) and password (password) in the configuration and make sure that they correspond to the information received from the MySQL server administrator." (translated back from my native language)

From reading around I presume I should use these configuration settings, but probably after getting mySQL active?
host: localhost
socket: /var/run/mysqld/mysqld.sock
Use SSL: check
Connection type: socket
Authentication type: config
User for config authentication: root  (or admin ?)
pass: 'leave blank'
accept login as root: check

Rest of settings left blank/default ?

Or are there any other settings that must be adjusted correctly for the ReadyNAS Ultra 4 and Owncloud combo ?