Ubuntu under the graphical Lamp Environment Configuration tutorial (Linux) _linux

Following the "Ubuntu under Lamp Environment Configuration tutorial (Linux)" (Click to open the link) to do a good job of lamp environment, you can use the Gredit text editor to write PHP, and then use the terminal to query the contents of MySQL, but this environment is quite rough, Without the development of the IDE, query the database to enter a lot of commands, not suitable for PHP development.

At this point you can install Aptana as PHP Development IDE, this tool in the "HTML" a good Front-End development Ide--aptana Studio (click to open the link) has been introduced. Use MySQL Workbeach as a graphical version of MySQL in Ubuntu because the MySQL Gui tools in Ubuntu are too old to start MySQL administrator and MySQL under Ubuntu 12.04 Query browser. Moreover, MySQL Workbeach is actually more useful than MySQL Gui tools.

Download, installation and use of Phpide--aptana

1, first open Aptana Studio's official website http://www.aptana.com/products/studio3/download (click to open the link), choose suitable for your Linux operating version of the Aptana click to download. This site is not wall, just if your network is not good, it is difficult to open.

2, to 32-bit Linux as an example, after downloading to get aptana_studio_3_setup_linux_x86_3.6.1.zip, put to Pc/home is your main file, direct extraction can.

3, after the proposed to get a Aptana Studio 3 actually here can be used. This is the same green version as Eclipse. At the same time the original download of the compressed file, the right button, thrown into the trash and emptied.

4, after, and "Android" using Adt-bundle in Linux easy to build the Android development environment and Hello World (click to open the link), for the inside of the Aptanastudio first create a link, do not copy directly to the desktop, As with Windows, you must first create shortcuts for. exe, and you can't drag it directly to the desktop.

5, to be dragged is the shortcut

6. After that, to rename the shortcut on the desktop, and change its icon. Change the selection properties of the icon.

7, in the Open Properties window, click on the icon

8, find just Aptana was unzipped the target, select its inside the icon file icon.xpm

9, open Apatan do not configure what, directly right-click Var/www in the following figure to create a new file, select New from template->php->php Template to write

10, debugging words, directly open Ubuntu with the wild Fox Zen Browser, input http://127.0.0.1/xx.php can access

Second, the use of MySQL Workbeach to make MySQL graphics

1, this thing with sudo apt-get install command installation is very troublesome, and installed the MySQL Workbeach is not the latest version, preferably or their own MySQL Workbeach official website http://dev.mysql.com/ downloads/workbench/(click to open link) to download, this is also the MySQL official own works. First select looking for previous GA versions, because the latest version has not supported Ubuntu12.04, found 6.0.9 version, choose Ubuntu Linux 12.04 32-bit or 64-bit download.

This site if the network is not good, this pull-down menu is not come out, after all, this site some JS loading does not come out, resulting in the Web page looks complete, but the actual incomplete.

2, after downloading, get mysql-workbench-community-6.1.7-1ubu1204-i386.deb, directly double-click the installation, let you enter the system's password directly input. The Ubuntu Software Center appears and the installation is automatically installed when you click on it.

3, after the successful installation, open usr/share/applications This folder, find the MySQL workbench this shortcut, directly copied to the desktop. Usr/share/applications this folder to directly store a bunch of shortcuts to existing programs.

4, double-click the Desktop shortcuts open, select the existing links, in the pop-up window directly select Connect

5, then enter the database password root, it is best to save the password to the Linux password chain.

6, for the system's password chain to read and write must enter the Ubuntu System Password Admin, and the above database password is different, pay attention to differences do not confuse.

7, open MySQL after the following figure, close some of the things do not. What really works is the following schemas, which is a bunch of our databases, also called strategies. If the button does not work, point to point to the buttons do not respond, restart Ubuntu is normal, although very funny, but it is so strange.

8, in the policy area or a blank place called the database right button, you can create a new database

9, the name of the input database, the key is to select a good database encoding, directly choose Utf-8, so that after you do anything to change the code, annoying!

10, click OK later, will display the corresponding SQL statement, directly select Apply, then complete the creation.

11, right key to the corresponding database tables can create a table

12, after the same as in the old Windows MySQL Gui tools, PK on behalf of the primary key, NN represents a Non-empty, AI represents automatic increment.

13. After the selection is confirmed, the corresponding SQL statement is displayed. Select Apply to complete the creation.

14. After that, you can enter the SQL statement in the upper-right blank area to complete the query.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.