We’ll show you how to create a PostgreSQL user in this article. Create a PostgreSQL account by following these steps. 1.Go to your “cPanel” 2.PostgreSQL Databases interface to “Create a PostgreSQL user”” 3.Fill in the “Username and Password” in the Add New User form. Note:- It’s worth noting that the username will always include your […]
Category: MySQL
How To Create A MySQL Database Connection In Dreamweaver
After setting up a MySQL user’s account and after Setting up the PHP / MySQL Site Definition in Dreamweaver now we are going to have a look at the process to create a MySQL database connection with Dreamweaver. After finishing the defining part you should approach the following MySQL connection dialog box in Dreamweaver. Connection […]
Script For Connecting Remote MySQL DB From Local Machine
In a few circumstances you may have to connect the MySQL Database from the local machine to web hosting server, following is the script you can use for the same. Remember you need to have the following information with you 1. Database URL and 2. Java applet – ‘com.mysql.jdbc.Driver’ – to connect it. Now you […]
How To Reset MySQL Password Using MySQL Command
In previous post we saw how to change MySQL password using mysqladmin command at shell prompt. But there is another way to do it by updating the MySQL database. As usernames and passwords are stored in a user table in MySQL database so you can directly change password of any user by following the below […]
How To Set / Reset MySQL Password?
Changing passwords is quite a regular type of task for many webmasters and the same is also applicable to database administrators also. Here I would like to share the procedure of changing the password of MySQL. The root user is the admin of a MySQL account. Remember that it is different than login into the […]