Java Web Hosting - JSP Management

my.cnf or /etc/my.cnf in Linux). Set max_allowed_packet to allow files as large as 16 megabytes: max_allowed_packet = 16M Save the file and restart MySQL so that the changes take effect. (In Windows you can do this from the MySQL icon in the system tray. In Linux, you can do this from the init script: /etc/init.d/mysqld restart.) Once MySQL is running again, set the password for the MySQL user named root. This root user has total control over the database. (The MySQL root user is not the same as the operating system’s root user and can have a different password.) >mysqladmin -u root password mypassword In Linux, mysqladmin is usually in the $PATH. In Windows, you may have to open a command shell and go to the C:mysqlbin directory. Next, connect using the mysql client: >mysql -u root -p mysql In the command above -u root indicates that you are connecting to the database as the root (administrative) user. You should only connect as root for administrative tasks (as we are about to do now). -p provides an interactive password prompt, and mysql at the end indicates the name of the database that we will use. A database server such as MySQL or Oracle can have many different databases, where each database is allocated to store some particular set of information. OpenCms will use its own database (which we will name opencms) to store its data. MySQL has its own database, named mysql, which contains information that MySQL uses to manage the other databases. The mysql database is used for storing information about permissions. MySQL uses this information to determine who has access to which databases. Once you have connected to the database, it is time to create the opencms database and add the user accounts that OpenCms will use to connect to that database. The MySQL command for creating a database is CREATE DATABASE [dbname], so the command to create a database named opencms is: mysql> CREATE DATABASE opencms; The semicolon at the end of the line indicates that the command is complete. (Without it you would get the prompt ->, which indicates that the SQL interpreter expects you to add more to the command. If this happens, you can just type ; to indicate that the command is
MySQL web hosting will be off your worry about list if you sign up with us,just trust us and go check MySQL Web Hosting services.