by johanc | Jul 19, 2022 | Databases, InfoTech
Solution to common problems that Windows servers have in allowing remote users to connect to MySQL. Windows Server is commonly used to run MySQL and MariaDB. The main problems that user may have connecting remotely to it can be through firewall settings blocking port...
by johanc | May 12, 2020 | Databases
One of the most frustrating things is installing MySQL and then forgetting what password you set for the root user. This has happened to me on more than one occasion. You can reset the password with the following procedure. If you run mysqld and get errors where it...
by johanc | Dec 18, 2019 | Databases
The SQL Server Single User Mode only permits one connection to a database at a time. Great for testing, but not for deployment. Here is how you can get it out of this state. Open the Microsoft SQL Server Management Studio. Start a new SQL query and enter the code...
by johanc | Dec 17, 2019 | Databases
When you backup a database and then later try to restore it, you might get a message that the database is in a restoring state. Here is how you can fix this. Open the Microsoft SQL Server Management Studio. Start a new SQL query and enter the code below with the...
