Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- osmc@osmc:~$ mysql -u kodi -pkodipass -h 192.168.10.19
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 2870
- Server version: 5.7.10 Source distribution
- Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | Main_Music48 |
- | Main_Music52 |
- | Main_Music56 |
- | Main_Video90 |
- | Main_Video93 |
- | Main_Video99 |
- | MyMusic48 |
- | MyVideos90 |
- | mysql |
- | performance_schema |
- | sys |
- | test |
- +--------------------+
- 13 rows in set (0.00 sec)
- mysql> use Main_Video99;
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- mysql> show tables;
- +------------------------+
- | Tables_in_Main_Video99 |
- +------------------------+
- | actor |
- | actor_link |
- | art |
- | bookmark |
- | country |
- | country_link |
- | director_link |
- | episode |
- | episode_view |
- | files |
- | genre |
- | genre_link |
- | movie |
- | movie_view |
- | movielinktvshow |
- | musicvideo |
- | musicvideo_view |
- | path |
- | season_view |
- | seasons |
- | sets |
- | settings |
- | stacktimes |
- | streamdetails |
- | studio |
- | studio_link |
- | tag |
- | tag_link |
- | tvshow |
- | tvshow_view |
- | tvshowcounts |
- | tvshowlinkpath |
- | version |
- | writer_link |
- +------------------------+
- 34 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement