MySQL setup help

Mark M

Mark M

Mark M

Soldato
Joined
6 Jan 2006
Posts
3,423
Location
Newcastle upon Tyne
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.
Click to expand...

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:

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

That returns the following error:

Code: 
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'];
 
Last edited:
try

CREATE USER 'mark'@'somehost' IDENTIFIED BY 'pass123';

the square brackets you will see in the manuals are optional parameters. So you could just as well use

CREATE USER 'mark'

but he wouldn't have a password.

then the grant so he can do something

GRANT ALL ON openbravopos.* TO 'mark'@'somehost';


somehost being where you created the database.
 
Last edited:
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'
Click to expand...

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

Access denied for user 'mark@openbravopos@localhost'
Click to expand...

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

Thanks.
 
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.
 
Last edited:
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.
 
The '> I think, indicates a non terminated string.
Basically it was waiting for you to write something else on the line which would be included in the string.

Glad it is all working for you now.
 
You must log in or register to reply here.
Back
Top Bottom