English | עברית
Linux - Ubuntu, MySQL, apache, WordPress
This tutorial explains the system information you need to install and manage WordPress project over Linux system with Ubuntu installation:

-          install mysql

https://help.ubuntu.com/12.04/serverguide/mysql.html

-          isnall ftp

https://help.ubuntu.com/10.04/serverguide/ftp-server.html

-          using putty to connect to the server with the ip address and SSH

-          using winscp over Putty configuration to windows directories browsing

apache configuration folder /etc/apache2/sites-available/*.conf

sudo nano /etc/apache2/sites-available/000-default.conf

<VirtualHost *:80>

        # The ServerName directive sets the request scheme, hostname and po$

        # the server uses to identify itself. This is used when creating

        # redirection URLs. In the context of virtual hosts, the ServerName

        # specifies what hostname must appear in the request's Host: header$

        # match this virtual host. For the default virtual host (this file)$

        # value is not decisive as it is used as a last resort host regardl$

        # However, you must set it for any further virtual host explicitly.

        #ServerName www.example.com

        ServerAdmin <server admin>@localhost

        DocumentRoot /var/www/html/<site directory>

#       DocumentRoot /var/www/html

<Directory  /var/www/html/<site directory> >

        Options FollowSymLinks

        AllowOverride All

</Directory>

        # Available loglevels: trace8, ..., trace1, debug, info, notice, wa$

        # error, crit, alert, emerg.

        # It is also possible to configure the loglevel for particular

        # modules, e.g.

        #LogLevel info ssl:warn

        ErrorLog ${APACHE_LOG_DIR}/error.log

        CustomLog ${APACHE_LOG_DIR}/access.log combined

        # For most configuration files from conf-available/, which are

        # enabled or disabled at a global level, it is possible to

        # include a line for only one particular virtual host. For example $

        # following line enables the CGI configuration for this host only

        # after it has been globally disabled with "a2disconf".

        #Include conf-available/serve-cgi-bin.conf

</VirtualHost>

-          Stop and start apache service

                sudo service apache2 start

-          dump my sql

 mysqldump -u misql -p mi-db > /home/mi-db.sql

-          connect mysql

mysql  -h <host ip> -u <user name> -p<password>

-          create db

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name

-          create user with previlege

CREATE USER '<user name>'@'localhost' IDENTIFIED BY '<password>';

GRANT ALL PRIVILEGES ON <db name>.* TO '<user name>'@'localhost'

link : http://dev.mysql.com/doc/refman/5.1/en/grant.html

-          restor db

mysql -u root -p[root_password] [database_name] < dumpfilename.sql

-          ftp service

get config location :

locate vsftpd.conf

/etc/passwd - list of all files in Linox

-          Understanding /etc/passwd File Format

http://www.cyberciti.biz/faq/understanding-etcpasswd-file-format/

-          manage user in ubuntu

http://www.cyberciti.biz/faq/ubuntu-add-user-to-group/

Comments
 
Leave a comment
 
   
 
 
 
Send
Rizotec
Established in 2004, Rizotec develops infrastructure management solutions, which help improve the performance and...
Hanit System v2
Hanit is a unique system developed for client X-Per-To (which merged with a group of Deloitte Brightman Almagor ...
Home    |    About Us    |    Portfolio    |    Contact us
Technical issues : support@item-soft.com | Comments : contactus@item-soft.com
Item Solutions www.item-soft.com
Hamaginim 7 p.t Israel 49442      Tel : 972-3-9341496