Here are some basic operations with the MySQL server. SQL Statements explains in detail the rich syntax and functionality of the SQL statements that are illustrated below. Showing existing databases. Use a SHOW DATABASES statement: Creating a new database. Use a CREATE DATABASE statement: Check if the database has been created: Creating a table inside ..
Archives : March-2021
Imagine you need to create a new database for some project like a simple blog, and you plan to do that with MySQL. So, in that case all you need is to install MySQL/MariaDB and, after MySQL server is up and running, you can connect to it as the superuser root with the mysql client ..
In WordPress, there is more than one way to reset your password.The one that we are going to explain here today is by setting a new password directly in MySQL Worpress database. First access your wordpress website files and find a file config.php.inc.Inside this file you will find the username the password the database name ..
Once I noticed a message in /var/log/samba/log on one of the servers with samba: The warning is displayed due to the fact that Linux has a default limit of 1024 simultaneously open files, and on Windows it is 16384.Therefore, we will increase the limit in Linux to 16384: Check: To prevent changes from being reset ..
Software installation With the help of apt command, install the following packages: As usual, Debian is asking us for the configuration details. For Samba 3, there are only two simple questions: Now we have our Samba configuration file as /etc/samba/smb.conf, now for future references we will save the original config file. To enable WINS, we ..
I recently setup a backend RDP server so that I could test our remote services. I went through the installation process and installed my RDP license on the server successfully.The problem was that I was not getting an error when logging onto the server locally to check the status of the RDP Server : I ..
Recent Comments