Jump to content
Sign in to follow this  
imamac

Root Mysql

Recommended Posts

In one of my accounts, I am attempting to install Open EMR (healthwebit.com). In the installer PHP script it requires a root MySQL password in addition to the user login/password. It does note that generally it can be left black, but I get this when I do:

 

openEMR Setup

 

Step 3

 

Connecting to MySQL Server...

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/******/public_html/openemr/openemr/setup.php on line 159

ERROR. Check your login credentials.

 

Access denied for user 'root'@'localhost' (using password: NO) (#1045)

 

 

Any suggestions here? Is there a "root" password? If so can it even be used on a shared server? Will TCH dash my dreams to pieces? :)

Share this post


Link to post
Share on other sites

Create a database in cPanel.

Create a user.

Add the user you created to the database.

 

For your configuration:

The database name will be your-cpanel-name_dabasename

The user will be your-cpanel-name_user

The password will be the password you used when you created the user.

 

Hope that helps.

Share this post


Link to post
Share on other sites

What you're referring to is the routine thing I've done a hundred times on many databases. But is asks for a root MySQL password in addition to that. I can post a link if it will help to see it.

Share this post


Link to post
Share on other sites
What you're referring to is the routine thing I've done a hundred times on many databases. But is asks for a root MySQL password in addition to that. I can post a link if it will help to see it.

I took a look at this script and they assume you have full access to the server and are not installing to a virtual account.

Since you do not have root access you need to create the database, then use the option "The databases have already been created" during setup.

Share this post


Link to post
Share on other sites
I took a look at this script and they assume you have full access to the server and are not installing to a virtual account.

Since you do not have root access you need to create the database, then use the option "The databases have already been created" during setup.

 

Thanks, I'll give it a try!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...