A PCRE internal error occured. This might be caused by a faulty plugin
====== Differences ====== This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
packages:amp:mysql [2013/12/18 01:45] admin [Install (the latest) MySQL Workbench] |
packages:amp:mysql [2014/09/24 02:42] (current) admin [Let Your MySQL Server Be Accessed From the Outside] |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| Easy! | Easy! | ||
| + | Once you have installed MySQL, we should activate it with this command: | ||
| + | <code> | ||
| + | > sudo mysql_install_db | ||
| + | </code> | ||
| + | Finish up by running the MySQL set up script: | ||
| + | <code> | ||
| + | > sudo /usr/bin/mysql_secure_installation | ||
| + | </code> | ||
| ===== Let Your MySQL Server Be Accessed From the Outside ===== | ===== Let Your MySQL Server Be Accessed From the Outside ===== | ||
| In order for other computers on your network to view the server you have created, you must first edit the "Bind Address". Begin by opening up Terminal to edit the my.cnf file. | In order for other computers on your network to view the server you have created, you must first edit the "Bind Address". Begin by opening up Terminal to edit the my.cnf file. | ||
| <code> | <code> | ||
| - | sudo gedit /etc/mysql/my.cnf | + | sudo nano /etc/mysql/my.cnf |
| </code> | </code> | ||
| Line 57: | Line 65: | ||
| You could easily install MySQL Workbench from the "Software Manager" application. Unfortunately the version that is available in there is quite outdated, 5.2.40, while version 6.0.8 is available on the [[http://dev.mysql.com/downloads/tools/workbench/|MySQL website]]. | You could easily install MySQL Workbench from the "Software Manager" application. Unfortunately the version that is available in there is quite outdated, 5.2.40, while version 6.0.8 is available on the [[http://dev.mysql.com/downloads/tools/workbench/|MySQL website]]. | ||
| + | |||
| + | === Download the .deb Installer === | ||
| + | At the bottom of the [[http://dev.mysql.com/downloads/tools/workbench/|MySQL Worbench download page]], select "Unbuntu Linux" as the platform. Then download the **Ubuntu Linux 13.04 (x86, 64-bit), DEB** version (you might have to select the 32-bit version depending on your system's architecture). Also if you didn't apply the LMDE UP7 upgrade, you'd better use the 12.04 version. | ||
| + | |||
| + | The insatller .deb file is now in your ~/Downloads directory, let's double click on it.\\ | ||
| + | The "Packager Installation" app shows you the state of the process... Done ! | ||
| + | |||
| + | You now have a "MySQL Worbench" icon in your "Applications > Programming" menu. | ||
