Home » Open Source » MySQL » MySQL user connection to database (MySQL 5.0, CentOS)
MySQL user connection to database [message #639993] Tue, 21 July 2015 03:29 Go to next message
reym21
Messages: 201
Registered: February 2010
Location: Philippines
Senior Member

Sirs,

We're a newbie to MySQL implementation, just to validate this:
Is the "root" account the only account that can connect to a database?

This was an outsource system before and after the warranty ends,
we're the one administering this right now.

Every time we connect to the database, we execute this command
'mysql -u root -p', although we had an account as DBA at the OS,
but we use the "root" password when connecting to the database.

Thank you.
Re: MySQL user connection to database [message #640013 is a reply to message #639993] Tue, 21 July 2015 06:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10679
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is the "root" account the only account that can connect to a database?
No. You can create different accounts with different privs.
As in any database/OS, connecting as the Super user for all operations is just bad.

[Updated on: Tue, 21 July 2015 06:11]

Report message to a moderator

Re: MySQL user connection to database [message #640388 is a reply to message #640013] Mon, 27 July 2015 20:37 Go to previous message
reym21
Messages: 201
Registered: February 2010
Location: Philippines
Senior Member

Sir,

Thanks for this confirmation.

I think that this should be raised to our Security Group,
said contractor deployed a "default" MySQL implementation.

Regards,
Previous Topic: Print Cursor output
Next Topic: Restore MySQL database with only datafile
Goto Forum:
  


Current Time: Tue Dec 12 12:58:45 CST 2017

Total time taken to generate the page: 0.06609 seconds