SQL username and password

[abelaguilar]

Anyone know if its possible to add a username and password to SQL?

I am trying to use a backup program that backups sql databases but it needs sql to have a username and password in order for it to access the database.

How can it be done and will it cause problems?

I called open dental and the support tech said that open dental was not intended to be used with a sql username and password.

[jordansparks]

The username is root and the password is blank. Also see http://www.opendental.com/manual/passwordsmysql.html

[medicusjim]

Log into root MySql account then create another dedicated account like this:

mysql> grant select on opendental.* to 'newuser'@'ip_address_of_connection_point' identified by 'password';

* Replace 'newuser' with some username.
* Replace 'ip_address_of_connection_point' with the IP address of the machine that will be connecting to the database server. This could be the backup server. Or, you can use '192.168.%' to allow connections for any server on the internal network.
* Replace 'password' with whatever you want the password to be.
* Since this is just a connection used for backups, "select" priv should be enough, but you could list other too "select,insert,update," etc.

-Jim