itech

MySQL root şifresini MySQL kurarken bir kere atarız ve root olarak erişmek istediğimizde üzerinden aylar geçtiği için unuturuz. Bu durumda aşağıdaki adımları konsolda uygulayarak root şifremizi sıfırlayabiliriz; #service mysqld stop  – MySQL servisimizi kapatırız #service mysqld_safe --skip-grant-tables & - MySQL’i safe modda açarken grant table’ları skip ederek başlamasını söyleriz #mysql -u root  – root olarak login oluruz mysql> set password=password('YeniŞifremiz');  – Yeni şifremizi belirleriz mysql> flush privileges;  – Bütün privilege’ları flush ederiz mysql> quit  – Konsol’a çıkarız #service mysqld stop  – MySQL’i durdururuz #service mysqld start - MySQL’i başlatırız

Getting locked out of a SQL Server can happen in a number of ways.  You could inherit a server that was managed by someone that left the company and only that person had System Admin rights for example. A recent encounter I had was were a database server was built and provisioned in one active directory domain and then moved and joined to another non trusted domain. All the accounts provisioned within the server include those for the DBA admins were basically useless since they couldn’t be authenticated.  The built in SA account is locked down per policy so no one knows the password. What do you do if you find that you are locked out of a SQL Server instance? The way I handle it is to start SQL Server in single user mode, launch SQLCMD and create a new user. I then still using SQLCMD grant the new user the system admin role.  Once I have the new user created I restart SQL Server Service and log in using the new credentials. I can then clean up the instance by granting proper access.