mysql
User Iam
vramnum10 at gmail.com
Wed Dec 13 07:47:10 UTC 2006
Thanks for the feedback
User Iam
On 12/12/06, maman durahman <durahman at gmail.com> wrote:
>
> There is a lot of way to lear mysql. May be ( i have not try it yet)
> an easiest way to install is XAMPP. With this you have mysql, apache,
> php in one package. Phpmyadminn too, i think.
>
> With xampp you need not to install a think. Just download xampp,
> extract to a folder, and start.
>
> Here is a complete writing about it, I found it from ubuntu forum and
> others;
>
> HOWTO: Setup easy web development environment (XAMPP)
> This is a how-to for setting up a web development environment easily.
> This guide will install the XAMPP lampp stack into /opt, setup an easy
> way to start it up and shut it down, and link a folder in your home
> directory to the webserver.
>
> WARNING
> This guide is aimed at a development environment only and should not
> be used as a public webserver. To setup a public webserver follow the
> directions on the Ubuntu wiki
> https://help.ubuntu.com/community/ApacheMySQLPHP
>
> As this is Ubuntu, all the major parts of a typical web server are
> included (in the main repo, or on the Ubuntu Server CD) and this is a
> great way to setup a server. The ubuntu developers have prepared a
> great web server and have made the process as seemless as possible.
>
> But what if even the official way is still to complicated? What if you
> just want a quick web server for development?
>
> Fortunately there is the XAMPP project:
> http://www.apachefriends.org/en/xampp.html. The XAMPP project bundles
> Apache, PHP4 & 5, Perl, mySQL, and a bunch of other
> utilities/applications into an simple package for Mac OSX, Windows,
> Solaris, and Linux. Obviously this HOWTO only deals with the linux
> version.
>
> For those of you with already existing Apache/mySQL/php installations
> it installs everything into /opt so it doesn't conflict with any other
> installation, and it is completely setup and ready to run.
>
> Install XAMPP
>
> Two easy steps:
>
> 1. Download the most recent version of XAMPP: (at time of writing
> 1.5.3a)
> http://prdownloads.sourceforge.net/x...ar.gz?download
> (Source URL: http://www.apachefriends.org/en/xampp-linux.html#374)
> 2. Extract the archive to /opt using sudo: (make sure you are in
> the directory that you downloaded the archive to)
> Code:
>
> sudo tar xvfz xampp-linux-1.5.3a.tar.gz -C /opt
>
>
> Start XAMPP
>
> To start it up, open a terminal and type this:
> Code:
>
> sudo /opt/lampp/lampp start
>
> Stop XAMPP
>
> To stop it, open a terminal and type this:
> Code:
>
> sudo /opt/lampp/lampp stop
>
> Additional XAMPP commands
>
> To see additional commands, open a terminal and type this:
> Code:
>
> sudo /opt/lampp/lampp
>
> Sweet XAMPP Control Panel
>
>
>
> To use the sweet gtk/python control panel:
>
> Run in a terminal:
> Code:
>
> gedit ~/.local/share/applications/xampp-control-panel.desktop
>
> Paste the following into the open file and save and exit.
> Code:
>
> [Desktop Entry] Comment=Start/Stop XAMPP Name=XAMPP Control Panel
> Exec=gksudo "python
> /opt/lampp/share/xampp-control-panel/xampp-control-panel.py"
> Icon[en_CA]=/usr/share/icons/Tango/scalable/devices/network-wired.svg
> Encoding=UTF-8 Terminal=false Name[en_CA]=XAMPP Control Panel
> Comment[en_CA]=Start/Stop XAMPP Type=Application
> Icon=/usr/share/icons/Tango/scalable/devices/network-wired.svg
>
> "XAMPP Control Panel" will show up in your applications menu under
> Internet. Use the Alacarte Menu Editor to move it around.
>
> Test to see if XAMPP is running
>
> Once XAMPP is up and running open firefox and go to: http://localhost/
>
> You should see the XAMPP test page:
>
>
>
> Location of files and uploading
>
> XAMPP by default uses /opt/lampp/htdocs as the root web directory. The
> easiest way to start working on files is to link a folder in your home
> directory into this directory.
> My user name is peter so I have /home/peter/public_html linked to
> /opt/lampp/htdocs/peter. So if I navigate to http://localhost/peter/ I
> get a listing of all the files/folders in that directory. (As long is
> there isn't a index.php/html/etc file)
> To set this up, run in a terminal:
>
> 1. Make public_html directory in home directory:
> Code:
>
> mkdir ~/public_html
>
> 2. Link to /opt/lampp/htdocs
> Code:
>
> sudo ln -s ~/public_html /opt/lampp/htdocs/$USER
>
> Now any files and folders you place in ~/public_html will be published
> to your personal webserver.
>
> Bookmark http://localhost/username to make this easy to access.
>
> WARNING - SECURITY
> http://www.apachefriends.org/en/xampp-linux.html#381
> Open holes:
>
> 1. The MySQL administrator (root) has no password.
> 2. The MySQL daemon is accessible via network.
> 3. ProFTPD uses the password "lampp" for user "nobody".
> 4. PhpMyAdmin is accessible via network.
> 5. Examples are accessible via network.
> 6. MySQL and Apache running under the same user (nobody).
>
> This doesn't leave your whole system wide open, but someone could hack
> your XAMPP installation, so be wary.
> To fix most of the security weaknesses open a terminal and run:
> Code:
>
> sudo /opt/lampp/lampp security
>
> START AND STOP PARAMETERS
> Parameter Description
> start Starts XAMPP.
> stop Stops XAMPP.
> restart Stops and starts XAMPP.
> startapache Starts only the Apache.
> startssl Starts the Apache SSL support. This command activates the
> SSL support permanently, e.g. if you restarts XAMPP in the future SSL
> will stay activated.
> startmysql Starts only the MySQL database.
> startftp Starts the ProFTPD server. Via FTP you can upload files
> for
> your web server (user "nobody", password "lampp"). This command
> activates the ProFTPD permanently, e.g. if you restarts XAMPP in the
> future FTP will stay activated.
> stopapache Stops the Apache.
> stopssl Stops the Apache SSL support. This command deactivates the
> SSL support permanently, e.g. if you restarts XAMPP in the future SSL
> will stay deactivated.
> stopmysql Stops the MySQL database.
> stopftp Stops the ProFTPD server. This command deactivates the
> ProFTPD permanently, e.g. if you restarts XAMPP in the future FTP will
> stay deactivated.
> security Starts a small security check programm.
> For example: To start Apache with SSL support simply type in the
> following command (as root):
>
> /opt/lampp/lampp startssl
>
> You can also access your Apache server via SSL under https://localhost.
> * What is where?
> What is where? A big question of our existens, here are some answers! ;)
> IMPORTANT FILES AND DIRECTORIES
> File/Directory Purpose
> /opt/lampp/bin/ The XAMPP commands home. /opt/lampp/bin/mysql
> calls
> for example the MySQL monitor.
> /opt/lampp/htdocs/ The Apache DocumentRoot directory.
> /opt/lampp/etc/httpd.conf The Apache configuration file.
> /opt/lampp/etc/my.cnf The MySQL configuration file.
> /opt/lampp/etc/php.ini The PHP configuration file.
> /opt/lampp/etc/proftpd.conf The ProFTPD configuration file. (since
> 0.9.5)
> /opt/lampp/phpmyadmin/config.inc.php The phpMyAdmin configuration file.
> * Stopping XAMPP
> To stop XAMPP simply call this command:
>
> /opt/lampp/lampp stop
>
> You should now see:
>
> Stopping LAMPP 1.5.5a...
> LAMPP: Stopping Apache...
> LAMPP: Stopping MySQL...
> LAMPP stopped.
>
> And XAMPP for Linux is stopped.
> * Uninstall
> To uninstall XAMPP just type in this command:
>
> rm -rf /opt/lampp
>
> The end.
>
> On 13/12/06, User Iam <vramnum10 at gmail.com> wrote:
> > Hi
> >
> > I want to learn MySQL
> >
> >
> > Did an apt-cache search MySQL
> >
> > There is a lot of stuff there!!!!!!
> >
> > What is the best min install...
> >
>
> --
> Wasalam,
> Durahman
> =====================
> http://durahman.wordpress.com/
> https://durahman.wordpress.com
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20061212/3fed5327/attachment.html>
More information about the ubuntu-users
mailing list