[Linux] graphical LAMP development environment in Ubuntu, ubuntulamp

[Linux] graphical LAMP development environment in Ubuntu, ubuntulamp

Follow [Linux] to configure the LAMP Environment In Ubuntu (click to open the link) to create a LAMP environment. Then, you can use the gredit text editor to write php, then use the terminal to query the content in mysql. However, this environment is still quite rough. If there is no development IDE, a large number of commands are required to query the database, which is not suitable for php development.

Now you can install Aptana as the php IDE. This tool has been introduced in [HTML], a good front-end development IDE -- Aptana Studio (click to open the link. Use Mysql WorkBeach as a graphical Mysql In Ubuntu. Because the Mysql Gui tools in Ubuntu are too old, MySql Administrator and Mysql query browser cannot be started under Ubuntu 12.04. Besides, Mysql WorkBeach is actually better than Mysql Gui tools.

I. phpIDE-download, install, and use Aptana

1. First open the official website of Aptana Studio http://www.aptana.com/products/studio3/download (click to open the link), choose the appropriate Linux Operating version of Aptana click to download. This website is not walled, but it is difficult to open it if your network speed is poor.

2. For example, download aptana_studio_3_setup_linux_x86_3.6.1.zip and put it in the pc/home file, which is your main file. Extract it directly.

3. After the proposal, we can get an Aptana Studio 3 which can be used here. This is also a green version like Eclipse. At the same time, right-click the downloaded compressed file and drop it into the recycle bin and clear it.

4. Later, you can use adt-bundle in [Android] to easily build an Android development environment in Linux and create a shortcut in Hello everyone. You cannot drag the shortcut to the desktop directly.

5. the shortcut to be dragged

6. Rename the shortcut on the desktop and change its icon. Change the selection attribute of the icon.

7. In the Open Properties window, click the icon

8. Find the target to which Aptana was extracted and select the icon file icon. xpm in it.

9. You don't need to configure anything to open Apatan. Right-click the file created in var/www and choose New From Template-> php Template to write

10. For debugging, open the Firefox browser that comes with Ubuntu and enter http: // 127.0.0.1/xx. php to access

Ii. use Mysql WorkBeach to visualize Mysql

1. Using the sudo apt-get install command to install the Mysql WorkBeach is not the latest version, it is best to your own Mysql WorkBeach official website http://dev.mysql.com/downloads/workbench/ (click to open the link) download, this is also the Mysql official work. Select Looking for previous GA versions first. Because the latest version does not support Ubuntu12.04, find version 6.0.9 and select 32-bit or 64-bit download from Ubuntu Linux 12.04.

If the website's network speed is not good, this drop-down menu cannot come out. After all, some JS files of this Website Cannot be loaded, which makes the webpage look complete but not complete.

2, download, get the mysql-workbench-community-6.1.7-1ubu1204-i386.deb, directly double-click the installation, let you enter the system password directly enter. The Ubuntu Software Center is displayed. Click Install to automatically install it.

3. After the installation is successful, open the usr/share/applications folder, find the MySQL WorkBench shortcut, and copy it directly to the desktop. The usr/share/applications folder directly stores shortcuts for a bunch of existing programs.

4. Double-click the shortcut on the desktop and select the existing link. In the displayed window, select connect.

5. Enter the Database Password root. It is best to save the password to the Linux Password chain.

6. to read and write the password chain of the system, you must enter the password admin of the Ubuntu system, which is different from the password of the above database. Do not confuse the difference.

7. After Mysql is enabled, close something that does not exist. What is really useful is the following Schemas, that is, a bunch of our databases, also known as policies. If the buttons do not work properly, clicking this button does not respond. It is normal to restart Ubuntu. Although it is funny, it is so strange.

8. Right-click the policy area or blank area of the database to create a new database.

9. Enter the database name. The key is to select the database encoding and select UTF-8 directly, so that you do not need to change the encoding in the future!

10. Click OK. The corresponding SQL statement is displayed. Select Apply directly to complete the creation.

11. Right-click the Tables in the corresponding database to create a table.

12. Later, like the old Mysql Gui Tools in Windows, PK represents the primary key, NN represents the non-null, and AI represents the auto increment.

13. After you select OK, the corresponding SQL statement is displayed. Select Apply to complete the creation.

14. Then, you can enter an SQL statement in the blank area in the upper right corner to complete the query.