MySQL 5.7 and OsCommerce setup

[Chadduck]

Since I began using OsCommerce back in it's early early days (v1.2 to be close) I have used the Mysql user of "root".

I just discovered that to connect to MySQL 5.7 the user "root" has to use 
sudo mysql --user=root mysql

Since this is the case, WHAT needs to be done to utilize existing databases and OsCommerce v4 with MySQL 5.7? 

Create a different user?
Changing the dbuser within OsCommerce to this different user?

Guidance would be greatly appreciated.

BJ
 

[Jack_mcs]

On 3/24/2024 at 4:40 PM, Chadduck said:

Since this is the case, WHAT needs to be done to utilize existing databases and OsCommerce v4 with MySQL 5.7? 

V4 requires php 7.4 or above. You need to install V4 into an account that can have 7.4 set. Then install the database conversion script into a subdirectory of the live shop and run it. See here.

[Chadduck]

@Jack_mcs

Thank you for your response however I think that my question was misunderstood.

What I was getting at was this

The existing database under OSC v3 was created by, owned by and was accessed by using "root" with password "xxxxxx" .  This is taken from the OSC v3 includes/configure.php file

  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'root');
  define('DB_SERVER_PASSWORD', 'xxxxxx');

During Step 3 of the OSC v4 setup, when identifying the DATABASE ACCESS when the server is set up using MySQL 5.7 can the Database username still be defined as "root"?

And IF doing that - will errors be encountered because of it?

Also, since the database was previously created and owned by root will accessing it with a DIFFERENT username cause problems?

I hope that better explains my question.

BJ

[Jack_mcs]

8 hours ago, Chadduck said:

The existing database under OSC v3

I am not familiar with that versions. The previous oscommerce version that V4 is compatible with it V 2.3.4. 

8 hours ago, Chadduck said:

can the Database username still be defined as "root"?

If you are trying to have V4 use an existing database, that won't work. The structures are different. If you mean you want to use the username and password that you already have for a new database, that should work as long as it is a valid login for the database.

[Chadduck]

39 minutes ago, Jack_mcs said:

If you mean you want to use the username and password that you already have for a new database, that should work as long as it is a valid login for the database.

THANK YOU

I was afraid that I was going to have to throw away the last  months of work. 

And you are correct my previous OSC version was 2.3.4.  I am also setting up a Joomla site which is v3.  Sorry I got my wires crossed.

Darn how how I hate upgrading servers.

BJ