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:43] admin [Add the Apache & PHP Modules] |
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 56: | Line 64: | ||
| Although my personal choice goes for MySQL Workbench. It has a lot more power and features than PhpMyAdmin and can even connect to remote hosts, providing a central management tool for your development environment as well as for your production one. That's only one of the many reasons that make me think it's much better suited on a development system that PhpMyAdmin. | Although my personal choice goes for MySQL Workbench. It has a lot more power and features than PhpMyAdmin and can even connect to remote hosts, providing a central management tool for your development environment as well as for your production one. That's only one of the many reasons that make me think it's much better suited on a development system that PhpMyAdmin. | ||
| - | 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 the | + | 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. | ||
