How to re-enable the grant table with mysql
root@dell:~# mysqladmin flush-privileges -uroot -p
When you create accounts with INSERT, it is necessary to use FLUSH PRIVILEGES to tell the server to reload the grant tables. Otherwise, the changes go unnoticed until you restart the server. With CREATE USER, FLUSH PRIVILEGES is unnecessary.
As usual when you modify the grant tables directly, you must tell the server to reload them with FLUSH PRIVILEGES so that the privilege changes take effect.
Tags: grant, mySQL, re-enable, tables
Set a new password using mysqladmin
shell> mysqladmin password “my new password”
Caution:
Do not use this command used if the server was started with the –skip-grant-tables option. No password change will be applied. This is true even if you precede the password command with flush-privileges on the same command line to re-enable the grant tables because the flush operation occurs after you connect. However, you can use mysqladmin flush-privileges to re-enable the grant table and then use a separate mysqladmin password command to change the password.
Tags: mysqladmin, new. password
Checking mysql extended-status
mysqladmin is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, and more.
root@dell:~# mysqladmin status -uroot -p
Enter password:
Uptime: 197 Threads: 1 Questions: 135 Slow queries: 0 Opens: 40 Flush tables: 1 Open tables: 34 Queries per second avg: 0.685
For Extended Status
root@dell:~# mysqladmin extended-status -uroot -p
Tags: Checking, extended, mySQL, status
Using Parallels Pro Control Panel to change the logo
To upload your logo to the server:
In the shortcuts area of the Home page, Click Upload Logo (Configuration section).
In the Upload new logo field, enter the name of your custom logo file including the full path or click
Browse to locate and select the file on your computer.
Note: Your logo size should not exceed 73 x 46 pixels.
Click Upload Logo.
Using the command line to change the logo
Using SSH, log on to the server as the root user.
Use either the move (mv) or copy (cp) command to move your logo.gif file to the customization directory /etc/appliance/customization/. For example:
mv /home/ftp_username/logo.gif /etc/appliance/customization/logo.gif
Where ftp_username is the user name of your FTP user account on the server.
Tags: Control Panel, logo, ParallelsPro, Using
IP-based and name-based Web sites.
There are two ways to host domains. The first is to create the domain with its own IP address. This is called IP-based hosting. You must create IP-based domains if the domain needs anonymous FTP and its own secure-site (SSL) support.
The second way to host domains is to create a domain that shares the primary IP address of the server. This is called name-based hosting. Name-based domains receive most of the benefits of an IP-based domain without occupying an IP address.
All of the standard sets of server applications are available to IP-based and name-based sites, except SSL encryption. SSL is not supported for name-based sites.
IP addresses happen to be scarce resources. To conserve IP addresses, you can arrange to have many sites share the same IP address.
Tags: IP-based, name-based, Websites
