[Fluffywelshsheep]

Okay desperation mode here, I am trying to set up a Shopping cart on my mum website but it requires me to create a database with permission for the user of SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP.

I have look up online tutorials but they are currently making no senses to me at all (MySQL or databases are not my strong point).

I have created a database called woodlandtu1 (default name) no tables. I have a username and password set up alread

Can anyone out their explain to me how or want am surposed to do next. I have phpmyadmin to manage it on www.streamline.net.

Please keep it simple as possible as my brain isn't working at all today.

Linz

[Tullywood Farm]

This is what I got from your link to the hosting company on SQL databases.

Usually you would already have a database of the products that you wish to sell, and could download them into the SQL.  If your mum uses Microsoft Access you could create a database in that and download it.

This is not an easy process, but if you have any database knowledge even Works Database, the principles are the same - it would be easier to show you, than tell you.

It would seem that you have to create a new database of the products that your mum wants to sell by keying in the information into this database as instructed below.

Hope this helps - Julie


Adding a MySQL database to your hosting package
If you have a Power, Unlimited or Bulk hosting package you can add MySQL databases to your website through the account control panel.

Step 1: Log into your account control panel.

Step 2: Click MySQL in the Product control section of the control panel.


Step 3: You will see a list of all the accounts you can add a database to. Create a new MySQL database by clicking Create.


Step 4: You will receive onscreen confirmation that the new database has been added to your account. This will also contain all the information required to access your database.


You can access your database with any MySQL administration tool you choose, or you can use the copy of phpMyAdmin we set up for you when you created your database. You can access phpMMyAdmin through your control panel by clicking the phpMyAdmin button in the Current mySQL databases section of your control panel.




 Tip: More information regarding phpMyAdmin can be found in the products documentation at: http://www.phpmyadmin.net.




Which version of MySQL am I using?


When you add your database in the account control panel, your database will be access to our latest SQL server, however if you have many different databases that you have created over time, it is possible that they will run on slightly different versions of MySQL. The versions are shown below:


MySQL1 to MySQL5 are running version 4.0.20.

MySQL6, MySQL7, MySQL8 are using version 4.1.15.

MySQL9 is using version 5.0.18.

MySQL10 and MySQL11 are using version 5.0.27

MySQL12, MYSQL13 and MYSQL14 are using version 5.0.22




 
 

[Fluffywelshsheep]

Thank you i got that far , but it's the permission bit that has me stumped.

My plan is to uses additional software to set up the 'shop' it just asking for me to set up the permission which am unsure of how to do and it's surposed to do the rest after that

Not had much luck with these systems at all.
I have sent an enquire off to the company for help but they take ages to answere my questions


Linz

[Paul Sill]

If the software going to create the database and all the required tables for you? If it is using php then the software should be able to write to the database with the username and password. What is the name of the program you are using? A quick google may give me a bit more information.

[Fluffywelshsheep]

yeah the software does all that but it's the setting up to allow the software to do it.
I was wondering does anyone know how to get the permisson on to the username, I just can't understand how to do this.

Does that make sense now?

Linz

[Tullywood Farm]

Hello Linz

I have never done this before myself, so not sure of the problem.

The link below may explain things further for you

all the best - Julie

http://www.databasejournal.com/features/mssql/article.php/2246271/Managing-Users-Permissions-on-SQL-Server.htm

[Fluffywelshsheep]

thank it give me what to look far but now what to type or input lol.

I think i need a Ubergeek anyone have one to hand?

Linz

[Dan]

Hi Linz

You need to insert a record into the db table in the mysql database. You can do this through phpMyAdmin.

Set the host to localhost, database name and user to whatever you have (case sensitive).

Set the permissions as required.

Save the record.

You then have to reload the MySQL permissions - from the home page of phpMyAdmin click the 'Reload permissions' link.

Your user should now have access to the database according to the permissions you've set.

Any problems feel free to ask for help.

Dan

[Fluffywelshsheep]

Set the host to localhost, database name and user to whatever you have (case sensitive).

Set the permissions as required.

Dan

thanks Dan how do i do this bit? am not sure what or where to put this bit

am sorry am feeling really dull at the moment
linz

[Dan]

No problem, happy to help, no-one was born knowing this stuff!

When you load phpMyAdmin you should see a list of databases in the left column. One of these will be mysql.

Click on it and you should see its tables listed in the right panel. One of these will be called db

Alongside db click on the insert icon (4th from the left) and you should get a blank form with spaces for Host, Db, User and a load of permissions.

If none of this makes sense email me your access details and I'll be happy to take a look.

Dan

[Fluffywelshsheep]

arhrrrrrrrrrrrrrrrrrrrrrhhhhhhhhh here lies to problem i don't have any of them databases lol.
Might be the problem why i was have such trouble finding them !

I'll have an investigation at this, Am off to find a book to try giving extra help .


On another note I supposivly attended a class in university on networks /databases etc but could never understand my Asian lecture (He was cantonesse with a weird accent). I did complain but it was never taken up as i was the only complaining and i don't think they wanted to attempt to do anything for the  'rasium' fear side of things.

I'll get back to you if i still can't figure things out (my pm/email)
Linz