Connecting to MySQL from NuSphere PhpED

DB Connection client is used to setup MySQL or other database account.
Setting up MySQL is very simple. You will need to:

• Click Tools -> Accounts on the menu bar or right-click on Accounts in DB Connection pop-up menu.
• In the Accounts dialog press New and select MySQL or right-click on Database accounts, choose New > MySQL as shown on the following illustration.

• Print the account name and press Enter.
• Enter a Hostname or IP address for of the MySQL database, and enter the appropriate Port for the account (the default is 3306).
• In the Initial Database field, enter the name of your MySQL database.
• Enter Authentication options: Login Name and Password for your MySQL database. Select the Save Password check box if you do not want to enter the password whenever you access the database. For Example, the following illustration shows how you can setup MySQL database connection account to MySQL database running on host with IP 192.168.1.102, with initial database set to "shopcart" and login as "priv_user".

Once your MySQL account is set up you can use it not just to browse the schema and data in the tables, but also to copy tables and databases names from MySQL to PHP code. To copy a MySQL database or table name to PHP code you need to simply:

• Select MySQL database or table in DB Connection Client
• Using right mouse button bring up a pop-up menu and select Copy. Look at this illustration that shows how to select and copy the name of the database "shopcart"
• Paste the copied MySQL database or table name in the PHP code
• You can also do the same operation by dragging MySQL database or table name from DB Connection Client directly to PHP Code