Re: deleted root user and pw in MySql

I think the problem may have been resolved, perhaps by the resetting
permissions process described in the link below. I went through the
steps earlier, before my last post, and when they didn't result in the
recreation of root, I thought it didn't work. However, using PhpMyAdmin
again, I just tried adding a user ("root") and it worked fine. I tested
it by creating a test database and then dropping it, both of which were
successful.

Currently, when I open PhpMyAdmin it says I'm logged in as an ordinary
user (not root), but as that user I was able to create and drop a
database.

Does that sound right, or am I still missing something?

Thanks.

Tom


http://tomrue.net

tomrue wrote:
I mistakenly deleted my root user and password via PhpMyAdmin. I'm
running FreeBSD 6.1 and MySql 5.1

I've googled this to death, but can't find a solution that works for
me. The most frequently pointed to web page that I found in response to
similar questions was

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Neither of the two alternatives offered for Unix environments proved
successful. Other than the lack of a route user my databases seem to be
running fine.

Can anyone advise me how to recreate root and give it a password??

Many thanks.

Tom


--
http://tomrue.net

.

Relevant Pages

  • Re: Creating n-tier solution
    ... create of a single record in the in the database. ... Collection.vb - Custom Strong Type Collection used in the DataAccess to ... Dim oRole as New [Root Name Space].Role ...
    (microsoft.public.dotnet.framework.aspnet)
  • [Full-disclosure] Appfluent Batabase IDS Local Root
    ... Appfluent provide a Database IDS system that monitors all SQL ... There is a stack based buffer overflow in all binaries that allow ... The problem is specific to the watcher process, ... run as root due to the fact that it ...
    (Full-Disclosure)
  • Re: Prevent Root access from database
    ... some other countries to take that approach. ... If root can access the database, without auditing, then you have a clear ...
    (comp.databases.oracle.server)
  • Re: How should I partition 2 80 gig drives?
    ... a web site or include some database stuff or name service. ... But, with that much disk, as long as you don't plan to serve a large ... The typical book and handbook examples of very tiny root and swap ... that last is true of all the file systems. ...
    (freebsd-questions)
  • oscommerce issue
    ... I'm running FreeBSD 5.4 with Apache 1.3, ... "1046 - No database selected ... Mail has the best spam protection around ...
    (freebsd-questions)