Is it a good idea to create a password and make your password secure for your Wordpress database when uploading the database to a third-party web host (going live instead of hosting on localhost) instead of root and no password? :

Change

u. root p. 'no password'

to

u. username p. password

Does it make your database more secure and still accessible to your new third-party host?

Is it a good idea to create a password and make your password secure for your Wordpress database when uploading the database to a third-party web host (going live instead of hosting on localhost) instead of root and no password? :

Change

u. root p. 'no password'

to

u. username p. password

Does it make your database more secure and still accessible to your new third-party host?

• database
• mysql
• phpmyadmin

• If the database is exposed to the internet, you could be able to use something like mysql -u root -h yoursite to connect to your database and create tables, modify data, or just delete everything, anybody would be able to do it – Tom J Nowell ♦ Commented May 28, 2019 at 15:33

1 Answer 1

The short answer is yes. Having a secure username and password is paramount to keeping your site secure.