How to play a movie with an external audio track in VLC
Posted by Alex On March 25, 2024
In a convenient context menu, you can select an audio track (for example, with different languages or dubbing from different studios). But this only works if all audio tracks are embedded in one video file. But what if you want to play a video in VLC along with the audio in a separate file? VLC […]
How to change the interface (menu) language of VLC media player in Linux
Posted by Alex On March 24, 2024
In VLC media player, in the settings there is an option to select the interface language. But this option is only present in the Windows version. In Linux there is no this option and you cannot change the language through the program settings. But the problem can be solved very easily in the console. How […]
How to increase the size of columns in phpMyAdmin
Posted by Alex On February 15, 2024
Table of contents 1. Why phpMyAdmin does not show the full contents of a cell (column) 2. How to view the full contents of a cell in phpMyAdmin 3. Why does changing column widths not show the entire data? 4.How to increase the number of characters in cells in phpMyAdmin Why phpMyAdmin does not show […]
How to search in phpMyAdmin
Posted by Alex On February 14, 2024
Table of contents 1. How does searching through databases and tables work in phpMyAdmin 2. Instructions for using the search function in phpMyAdmin 3. Search the database as a whole. Search multiple tables simultaneously 4. Single table search Conclusion How does searching through databases and tables work in phpMyAdmin Searching MySQL/MariaDB is performed using SQL […]
What is the difference between the LIKE operator and the equal sign (=) in MySQL/MariaDB. How to use LIKE in SQL
Posted by Alex On February 13, 2024
Table of contents 1. What to use to search in MySQL/MariaDB: LIKE operator or equals (=) operator 2. When to use equal sign (=) in SQL 3. When to use the LIKE operator in SQL 4. Even more differences under the hood Conclusion What to use to search in MySQL/MariaDB: LIKE operator or equals (=) […]
Case sensitive search in phpMyAdmin
Posted by Alex On February 12, 2024
Table of contents 1. Case sensitive search in phpMyAdmin 2. How to create a request with “BINARY” in phpMyAdmin 3. How can I make SQL case sensitive string search in phpMyAdmin 4. Video on how to find a case-sensitive string in phpMyAdmin Case sensitive search in phpMyAdmin Let’s try to find rows in the table […]
Case sensitive search in MySQL/MariaDB
Posted by Alex On February 12, 2024
Table of contents 1. MySQL/MariaDB search for strings not case sensitive 2. How to make search case sensitive in MySQL/MariaDB 3. Why do MySQL/MariaDB look for strings that are not case sensitive? 4. Why does adding “BINARY” make string searches case sensitive? 5. It is correct to put “BINARY” before the search string or before […]
How to migrate from X11 to Wayland?
Posted by Alex On February 12, 2024
Table of contents 1. Is Wayland or X11 better? 2. You may already be using Wayland 3. Which desktop environments support Wayland 4. Which display managers support Wayland 5. How to run Wayland 6. Setting up applications to work with Wayland 6.1 Setting up Firefox to work with Wayland 6.2 Setting up Google Chrome to […]
How to change Display manager and login screen in Linux
Posted by Alex On February 11, 2024
Table of contents 1. What is Display manager 2. What is needed to change Display manager 3. What types of display managers are there? 4. How to Find Out Which Display Manager is Used on Linux 4.1 Display-manager.service status 4.2 Symbolic link /etc/systemd/system/display-manager.service 5. How to change Display Manager 6. How to install the new […]
Menu buttons (toolbar) and status bar are missing in SMPlayer (SOLVED)
Posted by Alex On February 10, 2024
SMPlayer is a popular cross-platform video player. SMPlayer has many useful functions (crop video to fit the screen, fine-tune the appearance and location of subtitles, select the number of audio output channels) and many other settings, including those related to performance optimization and hardware acceleration of video decoding. Separately, I would like to note such […]