Thursday, 12 September 2019

How to install NEW CentOS Web Panel

For CentOS Web Panel Installation :
Step 1 – Login to your Centos7 server as root
Step 2 – Install Centos web control panel ( CWP ) using command below

run following command as root  (it runs 10-20 minutes):

yum update

yum install wget 

cd /usr/local/src

wget http://centos-webpanel.com/cwp-latest

sh cwp-latest



Login
———————
go to CentOS WebPanel Admin GUI at http://SERVER_IP:2030/
Username: root
Password: your root password
Configuration of WebPanel
– Setup nameservers
– Setup shared ip
– Setup at least one hosting package
– Setup root email
& now you are ready to host domains…


change port 22 in Contents of File: /etc/csf/csf.conf for reduce hacking chance
After installation i try to login in phpmyadmin I got error  '#1045 Access denied for user 'root'@'localhost' (using password: YES)'
for this I solve using this method:
login winscp as root
etc/my.cnf    
add this 
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
skip-grant-tables


or 
login putty

mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

Thursday, 5 September 2019

Using Putty SSH Client To Import Large MySQL Databases To PHPMyAdmin

In this tutorial i’ll show you how to use the Putty SSH client to import large MySql Databases from your public_html root directory to a New database in PhpMyAdmin.

  • Download Putty
  • Upload your My Sql database file to my sites public_html root directory
  • Create a new database using the MySql database wizard in cPanel
  • Enter a command line in Putty which imports the database to PhpMyAdmin
Once you have download Putty, Click the desktop shortcut and click run.
Next step is to enter your Hostname or I.P address and use port 22. If you are entering your hostname, leave out the http://www and simply enter yourdomain.com.
  • You can then enter your cPanel username and click enter
  • Then enter your password and click enter.
  • The final step is to enter the command line below
mysql -u database_user -p database_db < /home/username/public_html/database.sql
and click enter. (make sure to replace the path in blue & red with the correct address to your database. The filename for your SQL database file is in red. You’ll also need to replace the part in green with your new database username and password.
database_user = your database username
database_db = your db name
username = username ( hosting account username ) 
database.sql = database file name
after replace all details Enter 
now enter your database password and Enter
Wait now for uploading data in phpmyadmin
Make sure you have upload your database to the root( public_html) directory of your site as this is where it will be uploaded from to phpmyadmin.

Tuesday, 3 September 2019

Simple static style.css

Index.html
<!--- code start for index page -->

<html><head>
    <title>Test Style css</title>
    <LINK href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
    <div id ="wrapper">
    <div id ="header">
    <div id ="logo"></div></div>
    <div id ="navbar"></div>
    <div id ="container">
    <div id ="left-panel"></div>
    <div id ="right-section"></div>
    </div>
    <div style="clear:both"></div>
    <div id ="footer"></div>
    
    </div>
    

</body></html>

<!--- code end for index page -->

<!--- code start for style page -->


/**autor raj **/
*{padding:0; margin:0;}
#wrapper{padding:10px;}
#header{height:100px; background-color:#f1c233; padding:10px;}
#logo{width:150px; height:100px;background-color:#a20b32;}
#navbar{height:50px;background-color:#758209; margin-top:10px;}
#container{margin-top:10px;}
#container :: after{content: " "; display:block; clear:both;}
#left-panel{width:25%; height:600px; background-color:#eda150;float:left;}
#right-section{width:74%; height:600px;background-color:#bcc92b; float:right;}
#footer{height:100px;background-color:#79d17b; margin-top:10px;}

<!--- code end for index page -->

Simple responsive style.css

Index.html
<!--- code start for index page -->
<html><head>
    <title>Test Style css</title>
    <LINK href="style.css" rel="stylesheet" type="text/css">
    <meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"> 
</head>
<body>
    <div id ="wrapper">
    <div id ="header"></div>
 
    <div id ="content">
    <div id ="left-panel">
        <div id ="navbar"></div>
        <div id ="news"></div>
    </div>
    <div id ="right-section"></div>
    </div>
    <div style="clear:both"></div>
    <div id ="footer"></div>
 
    </div>
 
</body></html>
<!--- code end for index page -->

<!--- code start for style page -->

/**autor raj **/
@media(min-width:1200px){
#wrapper{padding:10px;}
#header{background-color:#ff1a75; height:100px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;}
#content{margin-top:15px;}
#content :: after{content: " "; display:block; clear:both;}
#left-panel{
    width:20%;
    height:600px;
    float:left;}
#navbar{
    background-color:#ff1a75;
    height:400px;
    -moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
}
#news{
    background-color:#ff1a75;
    height:200px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
margin-top:10px;
}
#right-section{
    background-color:#ff1a75;
    height:610px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
width:78.2%;
float:right;}
#footer{background-color:#ff1a75;
margin-top:10px;
height:100px;
    -moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
}
    }
 
 
@media(min-width:992px) and (max-width:1199px){
    #wrapper{padding:10px;}
#header{background-color:#ff1a75; height:100px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;}
#content{margin-top:15px;}
#content :: after{content: " "; display:block; clear:both;}
#left-panel{
    width:20%;
    height:600px;
    float:left;}
#navbar{
    background-color:#ff1a75;
    height:400px;
    -moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
}
#news{
    background-color:#ff1a75;
    height:200px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
margin-top:10px;
}
#right-section{
    background-color:#ff1a75;
    height:610px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
width:78.2%;
float:right;}
#footer{background-color:#ff1a75;
margin-top:10px;
height:100px;
    -moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
}
}
@media(min-width:768px) and (max-width:991px){
    #wrapper{padding:10px;}
#header{background-color:#ff1a75; height:100px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;}
#content{display:table; width:100%; margin-top:15px;}
#left-panel :: after{content: " "; display:block; clear:both;}
#left-panel{
     display:table-footer-group;
 
    }
#navbar{
    background-color:#ff1a75;
    height:100px;
    -moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
float:right;
width:78.2%;
}
#news{
    background-color:#ff1a75;
    height:100px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;

float:left;
width:20%;
}
#right-section{
    background-color:#ff1a75;
    height:610px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
margin-bottom:10px;
}
#footer{background-color:#ff1a75;
margin-top:10px;
height:100px;
    -moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
}
}
@media(max-width:767px){
    #wrapper{padding:10px;}
#header{background-color:#ff1a75; height:100px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;}
#content{display:table; width:100%; margin-top:15px;}
#left-panel :: after{content: " "; display:block; clear:both;}
#left-panel{
     display:table-footer-group;
 
    }
#navbar{
    background-color:#ff1a75;
    height:100px;
    -moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;

}
#news{
    background-color:#ff1a75;
    height:100px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
margin-top:10px;
}
#right-section{
    background-color:#ff1a75;
    height:610px;
-moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
margin-bottom:10px;
}
#footer{background-color:#ff1a75;
margin-top:10px;
height:100px;
    -moz-border-radius:15px;
-webkit-border-radius:15px;
border-radius:15px;
}
}

<!--- code end for index page -->