how to remove save password when connected to database

[sakshikaul]

Hi

Each time the sql querry gets fired it is asking for password. How to avoid the same?

[giovanneb]

When connecting, enter user id and password, follow

[sakshikaul]

I have 5 to 6 tables in my script(database), When each of them are executed its asking for password each time when it gets connected, so how can i avoid the same ?i need it should ask the password only once.

[Miguel_Angel_Baeyens · Accepted solution]

If as shown above, when creating the connection in Windows, you include username and password you will not need to specify it when executing the script