Learn Critical Computer Programming Concepts: Three books in one with code examples and hands-on projects by Skudaev Sergey

Author:Skudaev, Sergey
Language: eng
Format: epub
Published: 2021-06-28T00:00:00+00:00

After inserting the above mentioned values into the schedule table, we can query and view who is taking the course, at what time, who is teaching, etc.

Find a teacher name, who teaches the Java class:

SELECT

t.firstname, t.lastname

FROM teachers t INNER JOIN schedule s ON

t.teacherid=s.teacherid INNER JOIN courses c

ON s.courseid=c.courseid

WHERE c.coursename='Java';

If you lost password to MySQL

If you lost a mysql database password you can still gain access to your data.

The MySql directory has a "data" directory with directories for each database having the same name as the database. Inside the database directory is one db.opt file and three files for each table: one frm (table definition) file,

one MYD (table data) file, and one MYI (table indices) file.

You can copy the frm, MYD, and MYI files and move to another MySQL database.

It is not necessary to know the password to the database you copied the files from.

Install a new MySQL database:

Create a new MySQL database with a new password and create any table.

Open the data directory for the new MySQL database and open a directory with the same name. Then copy all your files into that directory, using db.opt, .frm. MYD and MYI for all the tables from the database with the lost password.

To access the new database with a new password:

mysql -u user -ppassword

select your database:

use databasename

and access your tables from the old database:

select * from table

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.