MySQL setup help

[Mark M]

Trying to install an OpenBravo POS software to test out and it runs off MySQL

Here is an extract from the installation guide but Im getting lost off after creating a new database:

On Windows
Download MySQL server (essentials package recommended) and install it.

Download MySQL Connector/J, unzip the contents and place it in the same folder where Openbravo POS resides.

Create an user and a database (schema).

You can check MySQL documentation.

An example of a database configuration using MySQL as database engine is:

Driver library: mysql-connector-java-3.1.6-bin.jar
Driver class: com.mysql.jdbc.Driver
URL: jdbc:mysql://localhost:3306/openbravopos
User: yourname
Password: yourpass
Note: if you copy/paste these values, make sure you do not have a blank space at the end of each string, i.e. "com.mysql.jdbc.Driver ", this will cause an error when executing Openbravo.

So Ive managed to get MySQL server essentials downloaded and installed and set up a new database using "create database openbravopos"

Im struggling on how to set up a user though. Tried following a guide on the web but keep getting an error. This is what Ive entered but obviously Im doing something incorrect:

mysql> grant all privileges on openbravopos.*@"mark" identified by "password";

That returns the following error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '@"mar
k" identified by "password"' at line 1
mysql> grant all privileges on openbravopos.*@"mark" identified by "password";

Any help greatly appreciated, thanks.

EDIT - just found another link which says to use the following code but it still wont work for me:

CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'];

 

[Mark M]

That seems to have worked thanks but sadly led to another problem now....

In the software Ive entered the username 'mark' and the password but I get the follwing error

Access denied for user 'mark@localhost'

So I thought I would alter the username to 'mark@openbravopos' but that gives the following error

Access denied for user 'mark@openbravopos@localhost'

Am I missing something obvious or do I need to seek advice from the software?

Thanks.

 

[Mark M]

Oh sorry, missed your edit there. Will try that now and report back

 

[Mark M]

I tried both the above and it doesnt do anything bar move onto the next line but it starts with '> rather than ->

I added a ' to the end of pass123, but it still does it without.

Daft question but I assume I created the DB in localhost? I just used CREATE DATABASE openbravopos.

Thanks again.

 

[Mark M]

You sir, are my hero!

Not sure why I couldnt get it to work when I added the ' Perhaps I left a space after something? Either way its up and running, thanks for all your help.