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?
mysql -u root -h yoursite.com
to connect to your database and create tables, modify data, or just delete everything, anybody would be able to do it