Recently I’ve been having issue creating MySQL user on RDS instance, suprisingly it is straight forward task as it seems. You can do this to create admin-level user for my MySQL databases. It can be used to replace the ‘root’ user with another full-permissions user, for slightly improved security. I was able to figure out the issue after going through MySQL documentation. The thing which wont work : Create User demo@'localhost' IDENTIFIED BY "demo@password";GRANT ALL PRIVILEGES ON *.* TO 'demo'@'localhost' WITH …
Tag: mysql
I’ve spent much of last 11 months with AWS customers and teams determining what it takes for a customer to migrate to AWS or any other public cloud platform, as per what I’ve seen, migrating to …
As DevOps engineer you always tend to run into issues related to databases, which is normal, as every application is different therefore it requires proper tunning of database inorder for them to work seemlessly. According to …
Following are the steps to change mysql server port : All these task are to performed on specified server and client side. Server Side • Install MySQL server : sudo aptget install mysqlserver5.6 • Configure MySQL …
Social Profiles