Connecting to Database via MySQL Workbench

You will need to open a Support Ticket with M3 Server.
CLICK HERE to open ticket.

M3 Server will need your IP.
CLICK HERE and you will be provided with your IP.
Note: We need the IP that our site reports so it can be whitelisted. IP should be static, not dynamic, or security will be weakened.

Once your IP has been whitelisted use these steps as follows:

1. Open MySQL Workbench

2. Click the Add icon

Screen Shot 2014-07-03 at 11.20.31 AM

3. Enter a connection name

Screen Shot 2014-07-03 at 11.36.56 AM

4. Select Standard (TCP/IP) as the connection method

5. Click the Advanced tab

Screen Shot 2014-07-03 at 11.39.07 AM

6. Check the box Use the old authentication protocol.

Screen Shot 2014-07-03 at 11.41.05 AM

7.  Clich the Parameters tab

Screen Shot 2014-07-03 at 11.41.56 AM

8. Fill in this information accordingly.

Screen Shot 2014-07-03 at 11.46.54 AM
Hostname yourserver.m3xs.net
Port 3306
Username Database Username
Password: Database Password

9.  Click store in keychain and you will be prompted to enter Database Password

Screen Shot 2014-07-03 at 11.46.34 AM

10. Click OK and you should now be able to connect to your Database

NOTE:
Using MySQL client from the command line, may give you the result:

Warning: Using a password on the command line interface can be insecure.
ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)

To bypass this, use the command line option:
–skip-secure-auth

The command line option will then resemble the following:
mysql –skip-secure-auth -u’yourdbusername’ -p’yourpassword’ -h v2505.m3xs.net

WordPress White Screen

WordPress is one of the most versatile scripts. However due to 3rd party scripts, themes, and plugins. WordPress can sometimes have problems. These problems usually break the php process and a white page is shown with no error. Here are most common causes and possible solutions.

BROKEN THEME

1. Log into M3Admin Control Panel
2. Click Database
3. Click DB Browser
4. Click Launch phpMyAdmin
5. Browse table wp_options
6. Go to page 2 change: Change the template and style sheet to twentytwelve.

INCOMPATIBLE PLUGIN

1. Open the File Manager
2. Open the wp-content folder
3. Rename the “plugins” folder to “plugins_old”
4. Create new empty folder called “plugins”
5. This will disable all the WordPress plugins
6. Refresh your WordPress site, and log into the WordPress Dashboard and verify site is working.
7. Enable plug-ins one at a time to see which one was causing the issues.

Note: the Memory_limit maybe maxed out.

Remove Database via M3 Admin Control Panel

Log in to your M3 Admin Control Panel

EXAMPLE: https://servernamehere.m3xs.net/adm/

Note: Put your server name where it says yourservername in the example URL above.

1. Click Database

Screen Shot 2014-06-04 at 6.04.52 PM

2. Click Delete

3. To the right of the database you want to remove, Click Delete

Screen Shot 2014-06-04 at 6.06.02 PM

4. To finalize Click Drop Database

Screen Shot 2014-06-04 at 6.06.14 PM

You have removed the database.

Click Here to Backup a Database
Click Here to Add a Database

Screen Shot 2014-05-29 at 5.17.59 PM

Remove Email via M3 Admin Control Panel

Log in to your M3 Admin Control Panel

EXAMPLE: https://servernamehere.m3xs.net/adm/

Note: Put your server name where it says yourservername in the example URL above.

1. Click Email

Screen Shot 2014-06-04 at 2.51.50 PM

2. Click List

3. Select the Domain that the Email is assigned to.

Screen Shot 2014-06-04 at 4.47.17 PM

4. To the right of the email address Click Remove Address

Screen Shot 2014-06-04 at 4.49.49 PM

5.  Click Confirm

Screen Shot 2014-06-04 at 4.52.45 PM

You have removed the Email Address

Click Here to Add an Email Adress Mailbox

Screen Shot 2014-05-29 at 5.17.59 PM

Add Email via M3 Admin Control Panel

Log in to your M3 Admin Control Panel

EXAMPLE: https://servernamehere.m3xs.net/adm/

Note: Put your server name where it says yourservername in the example URL above.

1. Click Email

Screen Shot 2014-06-04 at 2.51.50 PM

2. Click Add Mailbox

3. Enter email address and select the domain.

Insert Username & Password

Note: Keep strong passwords to increase security.

Screen Shot 2014-06-04 at 2.54.59 PM

4. Click Next

Screen Shot 2014-06-04 at 3.05.06 PM

5. Confirm Email Adress and Click Confirm

Screen Shot 2014-06-04 at 3.09.28 PM

6. Your Email Address has been added to Mailbox.

Note: Save the settings that you are provided as you will need them to set up email on local mail client.

Click Here to test on M3 Webmail
Click Here Tutorial on Email Settings

Screen Shot 2014-05-29 at 5.17.59 PM

Add Website/Domain via M3 Admin Control Panel

Log in to your M3 Admin Control Panel

EXAMPLE: https://servernamehere.m3xs.net/adm/

Note: Put your server name where it says yourservername in the example URL above.

1. Click Websites
Screen Shot 2014-06-03 at 5.21.34 PM
2. Click New
3. Fill in the Domain name.

Screen Shot 2014-06-03 at 5.25.59 PM

4.  Option 1: Use Existing FTP user

Select the FTP User

Screen Shot 2014-06-03 at 5.26.35 PM

Option 2: Create New FTP user

Screen Shot 2014-06-03 at 5.31.21 PM

Note: Keep strong passwords to increase security.

5. If you are wanting WordPress added to your site this can simplify a long process of manually adding to your site.

Screen Shot 2014-06-03 at 5.30.20 PM

6. If you plan on using this this domain to send and receive mail on your server Click Yes.

Screen Shot 2014-06-03 at 5.30.31 PM

7.  Click Submit

Screen Shot 2014-06-03 at 5.44.07 PM

8.  Review Settings and Click Confirm

Screen Shot 2014-06-03 at 5.46.08 PM

You now have created a website!

DNS updates take anywhere from an hour to 10 hours to update.
DNS requests are human reviewed for your security.

Click Here to Remove a Website Via M3 Admin Control Panel
Screen Shot 2014-05-29 at 5.17.59 PM