Introduction MySQL is the world most popular open source database because of its reliability, high-performance, and ease of use. MySQL has been designed and optimized for transaction processing and enterprises around the world rely on it. With the introduction of HeatWave in MySQL Database Service, customers now have a single database which is efficient for both […]

MySQL Database Service (aka MDS) is very popular and many users wants to benefit from the managed MySQL service and from MySQL HeatWave. We see many users migrating their data from MySQL on-premise or from another cloud vendor to MDS… we also see people migrating from other data-stores like PostgreSQL. In this article we will […]

We saw in this previous post how to import data from PostgreSQL to MySQL Database Service. Using almost the same technique, we will now import data from Amazon Redshift and import it to a MDS instance. With Redshit we have two options to export the data to CSV files that can be imported to MDS: […]

After having see how we can import data from PostgreSQL and Amazon Redshift, this time we will see how we can export data from Microsoft SQL Server and import it into MySQL Database Service in OCI. This time we will use something extra (for fun but also because it’s practical): OCI Object Storage ! The […]

When you create a MySQL Database Service instance in OCI, you have the choice between 3 types: If you have minutes as RTO (Recovery Time Objective) in case of a failure, you must choose a High Availability instance that will deploy a Group Replication Cluster over 3 Availability Domains or 3 Fault Domains. See Business […]

To setup point-in-time recovery for MDS using Object Storage, these are the prerequisites: In this article, I won’t focus on how to create a MDS instance, a compute instance, enable backups and Object Storage Bucket, this is easy and there is already a lot of literature about them (you can also check several of my […]

In part 1 of the series about Point-in-Time Recovery in OCI MDS, we saw how to stream the binary log to Object Storage. In this blog post, we will see how we can restore the data up to certain point. The high level process is simple: The scenario We have an application that constantly write […]

GT Cup 2021 For racing, as for the cloud, performance matters; and a few second faster will make a difference between win and lose.   Team Greystone GT and Oracle MySQL Database Service with HeatWave score maiden race win with Mason and Lancaster in GT Cup Greystone GT became race winners for the first time as Rich Mason […]

    One of the things I love about the MySQL Shell is that is saves your authentication credentials (no longer just passwords) in an obfuscated login path file named .mylogin.cnf. You can find that file in the %APPDATA%\MySQL directory on Windows or the current user's home directory on non-Windows systems. The file can be read later by MySQL client programs, such as the MySQL Shell, to obtain your authentication credentials for connecting to MySQL Server.

Which Credentials?

I had an email this morning from someone wanting to a) change the password stored by mysqlsh and b) find out which credentials are stored on the shell account being used.

Let's start out in reverse order.  The mysql_config_editor will show you the accounts with credentials saved for that login. 

$ mysql_config_editor print --all
[root@localhost]
user = "root"
password = …

GT Cup 2021 For racing, as for the cloud, performance matters; and a few second faster will make a difference between win and lose. Team Greystone GT and Oracle MySQL Database Service with HeatWave score maiden race win with Mason and Lancaster in GT Cup Greystone GT became race winners for the firs...