Re: Re3: uninstall MySQL

[eyang@xxxxxxxxx (Eric Yang)]

Hi Dan,

There are two records in the MySQL user table which allow you to define root user password.  I believe those records are loaded from existing database (the one you attempted to modify the password).

Here are the procedure to reset the database for MySQL:

# Shutdown MySQL

sudo /Library/Tenon/System/Scripts/MYSQL stop

# rename existing database

sudo mv /Library/Tenon/MySQL/var to /Library/Tenon/MySQL/var.old

# install new database

cd /Library/Tenon/MySQL/bin

sudo ./mysql_install_db

cd ..

sudo chown -R mysql.admin var

# Start up MySQL (or use the System Status to start it up)

sudo /Library/Tenon/System/Scripts/MYSQL start

This will reset your database back to the original.  Next, follow the guide:

http://www.tenon.com/support/itools7/phpMyAdmin-howto.shtml

There are some minor difference that you might change for your system.  It depends on your host name lookup configuration on the server.  As long as you keep the hostname the same in /Library/Tenon/phpMyAdmin/config.inc.php and in host column in MySQL user table for one of the root user record.  You should have the server configured properly.

In addition, after the correct configuration, you might need to purge your browser cache.  Some browser (IE) has a real bad caching habit which would result in wrong pages being served.  Hope this helps.

regards,

Eric

On Tuesday, May 20, 2003, at 01:33 PM, DC wrote:

> Thanks Eric, that worked to get rid of
> the extra icon.
>
> But I am still unable to access the MySQL
> databases using the phpMyAdmin
> interface. I was able to get to them the
> very first time I installed
> MySQL.pkg and navigated to it through the
> web interface, but when I started
> trying to set up a root passowrd, it
> stopped working.
>
> I tried to set up the root password
> because  error messages in red type on
> the main page of phpMyAdmin advised me
> to. Ever since I have been unable to
> access mySQL using
> phpMyAdmin.
>
> Now, I am stuck with no interface and the
> issue is not resolved by
> reinstalling the .pkg file.
>
> here is the error I see in both frames of
> the phpMyAdmin page:
>
>
>
> ---------------------------
> Welcome to phpMyAdmin 2.4.0
>
> Error
> MySQL said: 
>
> Access denied for user: 'root@localhost'
> (Using password: YES)
> ---------------------------
>
>
>
> Any ideas as to how I can get the
> phpMyAdmin to access MySQL again?
>
> I've done some debugging and found that I
> can access as root user the mysql
> and test databases via the mysql command
> line client:
>
> ---------------------------
> % cd
> /Library/Tenon/MySQL/bin
> % ./mysql -u root
>
> mysql> use mysql
> Database changed
> mysql> status
> --------------
> ./mysql  Ver 12.18 Distrib 4.0.12,
> for apple-darwin6.5 (powerpc)
>
> Connection
> id:         
> 1
> Current
> database:       mysql
> Current
> user:          
> root@localhost
> SSL:                    Not in
> use
> Current
> pager:         
> stdout
> Using
> outfile:         
> ''
> Server
> version:        
> 4.0.12
> Protocol
> version:       10
> Connection:             Localhost via UNIX socket
> Client characterset:   
> latin1
> Server characterset:   
> latin1
> UNIX
> socket:           
> /tmp/mysql.sock
> Uptime:                 5 min 2 sec
>
> Threads: 1  Questions: 12  Slow
> queries: 0  Opens: 11  Flush tables: 1 
> Open
> tables: 6  Queries per second avg:
> 0.040
> ---------------------------
>
>
>
> Also, I can see that the root user has no
> password required in the
> config.inc.php file, but each time I try
> to connect via the web interface, I
> see the 'Access denied'
> error.
>
> Thanks in advance,
> dan
>
>
> On 5/20/03 1:54 PM, "Eric Yang"
> <eyang@xxxxxxxxx> wrote:
> > sudo
> > /Library/Tenon/System/Scripts/installer.sh --delete
> > MySQL.pkg
>
> ---------
> Tenon Intersystems' iTools Mailing
> List
> To unsubscribe: send mail to
> itools-request@xxxxxxxxxxxxxxx
> with the body only containing:
> unsubscribe
> Find the searchable mailing list archives
> at:
> http://itools.blackpepper.co.nz/                               
>
>

--------------------------------------------------------------------------------------------------

Eric Yang                                                               Senior Software Engineer

Tenon Intersystems                                                                     eyang@xxxxxxxxx

1123 Chapala Street                                                            805-963-6983

Santa Barbara, CA 93101                                             http://www.tenon.com

--------------------------------------------------------------------------------------------------