TROUBLE TICKET SYSTEM   Online Instructions Open New Ticket Check Ticket Status Search by Key    [ search ] Topic - [ MySQL Databases ]    I want to learn how to use the MySQL database. Where I can find more information?    How to access my database online?    Is MySql database compatible with FrontPage?    What is MySQL ?    Do you support InnoDB storage engine?    Do you allow remote MySQL connections ?    Do you support Microsoft SQL or Microsoft Access databases?    What is a database?    What do I need to connect to a database ?    What is SQL?    What is a Database Engine?    What Database Engines do you support?    How do I create a MySQL database ? I want to learn how to use the MySQL database. Where I can find more information? There is a very good MySQL tutorial located on their own site. Please read it for more details. The tutorial is located here: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html. back to top How to access my database online? Go to the PHPMyAdmin section of the Control Panel and click on the database name in order to proceed to the login screen. Then use the following: Username: database_name Password: the database password you have assigned back to top Is MySql database compatible with FrontPage? No, it is not. back to top What is MySQL ? MySQL is a relational database management system (RDBMS). back to top Do you support InnoDB storage engine? InnoDB storage engine is not being supported. back to top Do you allow remote MySQL connections ? Remote MySQL connections are disabled. You will not be able to connect from an external host. Local connections are the only ones that are allowed. back to top Do you support Microsoft SQL or Microsoft Access databases? Microsoft SQL and Microsoft Access are property products which are not supported under Linux. There are workarounds but all of them come at high price - the resources required for their implementation are too high for production server environment. back to top What is a database? A database is a structured collection of records or data that is stored in a computer system. The structure and the organization of the data are defined by the database model which in most cases is a relational model. back to top What do I need to connect to a database ? In order to connect to a database you will need: database name database user database pass database host database port This information is available in the MySQL Databases section of the control panel. Please note that the database name = database user , i.e. whenever you add a MySQL database a MySQL user is created with the same name and this user is automatically added to the database. The database host is the name of the server on which your hosting account is located. The database pass is defined by you while you add a MySQL database. The database port is 3306. back to top What is SQL? SQL is a database language designed for the retrieval and management of data in relational database management systems (RDBMS). back to top What is a Database Engine? A database engine is the underlying software component that a database management system uses to create, retrieve, update and delete data from a database. back to top What Database Engines do you support? We support: MyISAM - Default engine as of MySQL 3.23 with great performance MEMORY - Hash based, stored in memory, useful for temporary tables ARCHIVE - Archive storage engine CSV - CSV storage engine FEDERATED - Federated MySQL storage engine MRG_MYISAM - Collection of identical MyISAM tables back to top How do I create a MySQL database ? You can add a MySQL database from the MySQL Databases section of the control panel. Enter the desired database name, enter the desired password and finally click on the Add SQL Database button. back to top © Copyright SupremeServer 2003. All rights reserved.