Hi, I went into VirtualMin->Edit Databases and then changed the User of the database to a new name.
(it was not an existing user)
The system updated but when I ran my php scripts they would not access the databases.
I checked the WebMin->System->Users and Groups to get a list of users and realised that the system did not create a user for the database.
Under VirtualMin I seem to be able to create users only under the Edit Mail and FTP Users.
But I don't want a mailbox for the database user !
Does the database user HAVE to be a mail user ? I am confused !
In WebMin->System->Users and Groups I see that I can create a User. Should I create my database user here under Webmin ?
If so I do not know how to create the pre-encripted password.
I see that all my virtualMin created users have pre-encrypted passwords, So would my user only have a "normal" password ? Is that inferior ? It sounds a lot less secure.
Would be very happy if someone could help me understand this so that I can get my website working again :)
Hello
Be nice to have an answer on this one.
Does it mean that a database user MUST be a mail user ?
Looks like it
Thanks
Hi Davvit
I didn't reply sooner because I don't have an answer to all of your questions ... ie, I don't kow if this can be done from withing Webmin/Virtualmin to keep all the server admin in one place.
If I need additional database users which are not mail/ftp users I use phpMyAdmin, the web based MySQL front end. I install this anyway on every server I set up and it makes administering MySql very easy.
hope this helps in the absence of a Webmin/Virtualmin anwser
A couple of additional thoughts --
The system updated but when I ran my php scripts they would not access the databases.
Well, yeah... all your PHP apps have a database username, password, and DB name in them.
If you go into Virtualmin or phpMyAdmin or whatever and change any of those on the system, your PHP apps still have the old values stored in them.
That just means you'll need to edit your config files for your web apps, and update them to use the new values.
But I don't want a mailbox for the database user !
While you can disable the actual mailbox for any user -- for better or worse, a system user is created whenever you create a database user.
If you don't want email, click on the users name in Edit mail and FTP users, and disable email for them.
-Eric
Thanks., I decided to leave it with its email account. Sorry - I think it was just the heading "Edit mail and FTP users" that throw me, I just wanted a db user.
I used to use phpMyAdmin when I had a Cpanel, but I want to get fully used to using VirtualMin. Since I pay for it I might as well use it. The more I use it the I learn and understand it.