MySQL Database Issue’s


MySQL Database Issue’s
Knowning MySQL Database Issue’s are as Follows

Issue’s
MySQL Access Denied for User root@localhost Issue
MySQL Admin Password Issue
MySQL Error 1146 “Table Doesn’t Exit”

Advertisements

MySQL Error 1146 “table doesn’t exist”


Error
mysqldump: Got error: 1146: Table ‘db_name.table_name’ doesn’t exist when using LOCK TABLES

Checking Error
mysqlcheck -u mysql_username -p database_name

Checking & Repair Tables
database_name.table_name
Error: Table ‘database_name.table_name’ doesn’t exist
status: Operation failed

Re-Entering The Data in MySQL
mysql -u mysql_user -p
mysql> use database_name
mysql> show tables;
mysql> quit

MySQL Admin Password Issue


MySQL Admin Password Issue
Reseting lost MySQL Admin Root password in Linux

Stopping MySQL Service
service mysql stop

Starting MySQL Server Without Password
mysqld_safe –skip-grant-tables &

Login MySQL
mysql -u root

Setup MySQL New Password
use mysql;
UPDATE user SET password=PASSWORD(“NEW-ROOT-PASSWORD”) WHERE User=’root’;
FLUSH privileges;
quit

Re-Starting MySQL Service
service mysql restart

MySQL Backup


MySQL Backup
The mysqldump command is used to create textfile “dumps” of databases managed by MySQL. These dumps are just files with all the SQL commands needed to recreate the database from scratch. The process is quick and easy.

Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command. In this article, let us review several practical examples on how to use mysqldump to backup and restore.

index

MySQL Database Backup Script
MySQL All Database Script
Multiple Database Backup Script

MySQL Installation Process


MySQL Installation Process
MySQL provides a Yum-style software repository for the following Linux platforms
EL5, EL6, and EL7-based platforms (for example, the corresponding versions of Red Hat Enterprise Linux, Oracle Linux, and CentOS)
Fedora 22 & 23
Currently, the MySQL Yum repository for the above-mentioned platforms provides RPM packages for installing the MySQL server, client, MySQL Workbench, MySQL Utilities, Connector/ODBC, and Connector/Python (not all packages are available for all the platforms; see Installing Additional MySQL Products and Components with Yum for details).

mysql

MySQL Commands


MySQL Commands
The MySQL™ software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. MySQL is a trademark of Oracle Corporation and/or its affiliates, and shall not be used by Customer without Oracle’s express written authorization.

MySQL Basic Commands
MySQL Backup Commands

Webmin


Webmin
Webmin is a web-based system configuration tool for Unix-like systems, although recent versions can also be installed and run on Windows. With it, it is possible to configure operating system internals, such as users, disk quotas, services or configuration files, as well as modify and control open source apps, such as the Apache HTTP Server, PHP or MySQL.

Webmin is largely based on Perl, running as its own process and web server. It defaults to TCP port 10000 for communicating, and can be configured to use SSL if OpenSSL is installed with additional required Perl Modules.

It is built around modules, which have an interface to the configuration files and the Webmin server. This makes it easy to add new functionality. Due to Webmin’s modular design, it is possible for anyone who is interested to write plugins for desktop configuration.

Webmin also allows for controlling many machines through a single interface, or seamless login on other webmin hosts on the same subnet or LAN.

figure1.png

PhpMyAdmin


PhpMyAdmin
phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions. The software, which is currently available in 78 languages is maintained by The phpMyAdmin Project.

It an import data from CSV and SQL, and transform stored data into any format using a set of predefined functions, like displaying BLOB-data as images or download-links.

screen11-access-phpmyadmin

LibreOffice Base


LibreOffice Base
LibreOffice Base allows the creation and management of databases, preparation of forms and reports that provide end users easy access to data. Like Microsoft Access, it can be used as a front-end for various database systems, including Access databases (JET), ODBC data sources, and MySQL or PostgreSQL.

413168_e420_3