< 1 2 3 4 5 > >>   Sort: Rank

Major Storage Engines Supported in MySQL in MySQL
What Are Storage Engines in MySQL? Storage engines are programs that are integrated into MySQL database management system to manage data tables. MySQL 5.0 supports the following major storage engines: MyISAM Storage Engine - MySQL default storage engine. Based on ISAM database concept. MyISAM is not...
2017-09-12, 265👍, 0💬

Testing New User Account and Password in MySQL
How To Test a New User Account and Password in MySQL? If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting to the server with user names and passwords: &g...
2017-09-08, 352👍, 0💬

Predefined User Accounts in MySQL
What Are the Predefined User Accounts in MySQL? There is only one predefined user account called "root": "root" was created during the installation process. "root" has no password initially. You need to assign a new password as soon as you finishes the installation. "root" has all access privileges ...
2017-09-08, 303👍, 0💬

Changing Your Own Password in MySQL
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of your own user account, you should use your user account connect to the server "mysql" first. You should then use the "SET PASSWORD ..." command to change the password of the current user account. The...
2017-09-08, 295👍, 0💬

Chaning Other User's Password in MySQL
How To Change the Password of Another User Account in MySQL? If you want to change the password of someone else's user account, you can connect to the server as "root" and use the "SET PASSWORD FOR userName ..." command to change the password of another user account. There are two ways to use this c...
2017-09-08, 295👍, 0💬

Adding a New User Account in MySQL
How To Add a New User Account in MySQL? If you want to add a new user account, you can connect to the server as "root" and use the "CREATE USER ..." command. The command syntax for create a new user account with a specified user name and password is: CREATE USER userName IDENTIFIED BY 'passwordStrin...
2017-09-08, 289👍, 0💬

Backup Tables by Copying MyISAM Files in MySQL
How To Backup Tables by Copying MyISAM Table Files in MySQL? To easiest way to backup MyISAM tables is to copy the data files to a backup directory. But this is not the recommended way to do backups. Read the backup FAQ collections for more details. The following tutorial exercise shows you how to a...
2017-09-01, 303👍, 0💬

Data File for MyISAM Storage Engine in MySQL
Where Table Data Is Stored by the MyISAM Storage Engine in MySQL? By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, each database will have its own subdirectory to store table data. If a new table is created with the MyISAM sto...
2017-09-01, 299👍, 0💬

Tables Using InnoDB Storage Engine in MySQL
How To Create a New Table Using the InnoDB Storage Engine in MySQL? InnoDB storage engine was developed by Innobase Oy, which is an Oracle company now. InnoDB is transaction safe, and has been used by a number of large Websites, like Slashdot.org. InnoDB is not the default storage engine. You need t...
2017-09-01, 289👍, 0💬

Repair MyISAM Tables in MySQL
How To Check and Repair MyISAM Tables in MySQL? If you have a corrupted MyISAM table, like the one resulted from the previous tutorial exercise, you can use the "CHECK TABLE" and "REPAIR TABLE" commands to try to repair it. The following tutorial exercise gives you a good example of repairing a corr...
2017-09-01, 285👍, 0💬

Restore Tables by Copying MyISAM Files in MySQL
How To Restore Tables by Copying MyISAM Table Files in MySQL? If you have old copies of MyISAM table files, you can restore them easily by copying them back to the data directory to replace the current table files. However you may need to shut down MySQL server to do this, because the current table ...
2017-09-01, 254👍, 0💬

Giving Privileges at Server Level in MySQL
How To Grant User Privileges at the Global Level in MySQL? If you want to grant a user privilege at the global level, you can use the "GRANT privilegeName ON *.* TO userName" command. The argument "*.*" in the command stands for all database and all tables. The following tutorial exercise shows you ...
2017-08-21, 359👍, 0💬

Revoking User Privileges in MySQL
How To Revoke User Privileges in MySQL? If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a privilege on a specific database, if that privilege was...
2017-08-21, 340👍, 0💬

Viewing User Privileges in MySQL
How To View User Privileges in MySQL? If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userName" command. The following tutorial exercise shows...
2017-08-21, 331👍, 0💬

Giving Privileges at the Database Level in MySQL
How To Grant User Privileges at the Database Level in MySQL? If you want to grant a user privilege at the database level, you can use the "GRANT privilegeName ON databaseName.* TO userName" command. The argument "databasename.*" in the command stands for all tables in the specified database. The fol...
2017-08-21, 303👍, 0💬

Giving User Read-only Access in MySQL
How To Give a User Read-Only Access to a Database in MySQL? If you want give a user read-only access to a database, you can grant to him/her only the "SELECT" privilege, so that he/she can not run any DDL statements, and any INSERT, UPDATE, or DELETE statements. The tutorial exercise gives you a goo...
2017-08-21, 262👍, 0💬

Tables Using BDB Storage Engine in MySQL
How To Create a New Table Using the BDB Storage Engine in MySQL? BDB (BerkeleyDB) storage engine was originally developed at U.C. Berkeley. It is now maintained by Sleepycat Software, Inc., which is an Oracle company now. BDB is transaction safe, and has been used in products from many companies, li...
2017-08-13, 376👍, 0💬

Starting mysqld to Support BDB Storage Engine in MySQL
How To Start mysqld to Support the BDB Storage Engine in MySQL? The default "mysqld" program does not support the BDB storage engine. If you want to use the BDB storage engine, you can start MySQL server with the "mysqld-max" program. The tutorial exercise below shows you how to start "mysqld-max" a...
2017-08-13, 332👍, 0💬

Data File for InnoDB Storage Engine in MySQL
Where Table Data Is Stored by the InnoDB Storage Engine in MySQL? By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, InnoDB storage engine will create 3 files to store and manage all tables that use the InnoDB storage engine: ib...
2017-08-13, 301👍, 0💬

Data File of BDB Storage Engine in MySQL
Where Table Data Is Stored by the BDB Storage Engine in MySQL? By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, the BDB storage engine will create one file for each table to store table data and index data. If a new table is c...
2017-08-13, 290👍, 0💬

Tables Using CSV Storage Engine in MySQL
How To Create a New Table Using the CSV Storage Engine in MySQL? CSV (Comma-Separated Values) storage engine stores table data in text files in comma-separated value format. CSV is not the default storage engine. You need to specify "ENGINE = CSV" at the end of the "CREATE TABLE" statement to create...
2017-08-13, 266👍, 0💬

Transaction Management: Commit or Rollback in MySQL
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Transaction Management: Commit or Rollback in MySQL. Clear answers are provided with tutori...
2017-08-08, 363👍, 0💬

Show Storage Engines Supported in MySQL in MySQL
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL? If you want to know exactly which storage engines are supported in your MySQL server, you can run the "SHOW ENGINES" command as shown in the tutorial example below: mysql&gt; SHOW ENGINES; +------------+---------+-----. ..
2017-08-08, 300👍, 0💬

Data Removed in MEMORY Tables in MySQL
What Happens to MEMORY Tables When MySQL Server Is Stopped in MySQL? If you have data rows stored in a table with the MEMORY storage engine, and the MySQL server has been shut down by the DBA, all data rows will be removed. But the table structure will remain in the server. The tutorial exercise bel...
2017-08-08, 293👍, 0💬

< 1 2 3 4 5 > >>   Sort: Rank