1. You have to reassign a new

jhnbrwn — Wed, 04 May 2011 00:11:54 +0000

1. You have to reassign a new password for root user, dont leave it blank.
2. Create a new user with lmited access.
3. All of your applications must apply the new user role.
4. Else, you can still use root user access, but supply with a good password.

First of all, you have to login into your mysql client utility with admin/root user access.

CREATE USER
Code:
GRANT ~YOUR ACCESS HERE~
ON ~DATABASE AND TABLE~
TO ~USERNAME@HOSTNAME~
IDENTIFIED BY ~YOUR PASSWORD~
The code above is also create the user, not jutst giving some access.

E.Q:
Code:
GRANT SELECT, INSERT, UPDATE, DELETE
ON YourDatabase.*
TO 'MyName'@'localhost'
IDENTIFIED BY 'MyPassword'
Or maybe you want to change root user passw.
Code:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('YourNewPassword')

Yes ,,,,,,,you are

sneha123 — Wed, 19 Jan 2011 09:52:16 +0000

Yes ,,,,,,,you are right........thanks for nice question....then i agree with you,,,,,,,,,,,,

you need to develop

stokes1900 — Thu, 28 Oct 2010 11:03:55 +0000

you need to develop application with user that have access level according their privelege. you have choice to create views in mysql . you need to do some research on this.

well, I suppose you're not

underscore — Sat, 19 Dec 2009 09:25:45 +0000

well, I suppose you're not meaning to give them access to run SQL queries, so you won't actually create users with different permissions, you'd rather code the php/asp/anything of your site in order to authenticate users and allow them to access only some parts of the website

you usually do this with a table where you save your usernames and passwords ( and email and everything else you need to store for each account ) and an access level, so depending on the access level you will let them do just few things in case they are standard users, or you will allow them do manage everything if the logged in user is an admin.

You need some development experience to translate this into something that will actually work.

Yikes, that is a large

Shaggy — Tue, 06 Oct 2009 14:55:47 +0000

Yikes, that is a large question!
I'd start off by reading about database design. Setting up your database schema so the data you intend to store can be read and written in the manner you wish.

While you are designing, keep in mind the security access you mention, as well as any reporting you'll want to do now and into the future

Searching for "database design tutorial" brings up many good looking pages.

Your next step is creating the software that interacts with the database you've just designed. Choose the language you want to implement in, and search for tutorials that will get you started.

Hope this helps.
Cheers,
Shaggy