Sponsored Content
Operating Systems Linux MySQL4 config messup on Suse9.1 How to reset? Post 85100 by Mark Ward on Saturday 1st of October 2005 07:49:42 AM
Old 10-01-2005
MySQL4 config messup on Suse9.1 How to reset?

I'm trying to run phpBB2 software on Apache2, all was fine with setups except I had no password protecting my database.

After researching how to do it, I attempted to set password "freddy" to root (for obvious reasons "freddy" isn't the actual pw I used).

I now can't login to MYSQL4 using root at all, I have to use "mysql -u freddy". Then I'm logged in as "freddy@localhost" but still with no password.

Logging is as root I get:-

# mysql -u root

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Logging in as "Freddy" I get:-

# mysql -u Freddy

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.14-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


I've tried reinstalling MYSQL4, but the config data remains.

Could anyone help me remove the user "freddy" and add a password to protect the root login?

I'd be happy to delete all & start again as the db currently contains no data at all.

Many thanks,

Mark.

Last edited by Mark Ward; 10-01-2005 at 09:09 AM..
 

9 More Discussions You Might Find Interesting

1. Linux

Suse9.0 + Apche2

Does anyone successfully compile Apche2.0.50 on Suse9.0? After run ./configure, and type "make" command, it always stops at this point: ------- .... /home/hiep/httpd-2.0.50/srclib/apr/libtool --silent --mode=link gcc -g -O2 -pthread -DLINUX=2 -D_REENTRANT -D_XOPEN_SOURCE=500 -D_BSD_SOURCE... (0 Replies)
Discussion started by: hiepng
0 Replies

2. Linux

SUSE9.1 Peculiar Gigabit Lan performance.

I'm having some peculiar performance issues with my Gigabit Lan. I have some 100Mb devices so I can't do the necessary "jumbo Frame" tweaks for absolute optimum performance as I'd prevent them access. I'm getting appauling transfer rates sending files to the linux machine, around 10 Mbps 3%... (0 Replies)
Discussion started by: Mark Ward
0 Replies

3. Post Here to Contact Site Administrators and Moderators

I would like to reset my password

Hi Moderators, I forgot the login password and am accessing the forum page through save form password credentials. Could you please reset my password ? Thanks, :) (5 Replies)
Discussion started by: matrixmadhan
5 Replies

4. Shell Programming and Scripting

parsing config file to create new config files

Hi, I want to use a config file as the base file and parse over the values of country and city parameters in the config file and generate separate config files as explained below. I will be using the config file as mentioned below: (config.txt) country:a,b city:1,2 type:b1... (1 Reply)
Discussion started by: clazzic
1 Replies

5. SuSE

GCC 3.2 on Redhat8 and Suse9

Hi, Can someone tell me what will be the difference between the binary that is built on Redhat8 and Suse9 even when compiler version is same i.e GCC 3.2.3 is used on both?I mean if I build an application on Suse9 using GCC 3.2that was supposed to be built on Redhat8 using GCC 3.2 what all... (1 Reply)
Discussion started by: kavya
1 Replies

6. Programming

GCC V3.2 on Redhat8 and Suse9

Hi, Can someone tell me what will be the difference between the binary that is built on Redhat8 and Suse9 even when compiler version is same i.e GCC 3.2.3 is used on both?I mean if I build an application on Suse9 using GCC 3.2that was supposed to be built on Redhat8 using GCC 3.2 what all... (4 Replies)
Discussion started by: kavya
4 Replies

7. Shell Programming and Scripting

Shell script that will compare two config files and produce 2 outputs 1)actual config file 2)report

Hi I am new to shell scripting. There is a requirement to write a shell script to meet follwing needs.Prompt reply shall be highly appreciated. script that will compare two config files and produce 2 outputs - actual config file and a report indicating changes made. OS :Susi linux ver 10.3. ... (4 Replies)
Discussion started by: muraliinfy04
4 Replies

8. Red Hat

Apache virtual host config vs global config problem

Hi folks, I am trying to configure Apache webserver and also a virtual host inside this webserver. For Global server config: /var/www/html/index.html For virtual host config: /var/www/virtual/index.html Both client10 & www10 are pointing to 192.168.122.10 IP address. BUT, MY... (1 Reply)
Discussion started by: freebird8z
1 Replies

9. Windows & DOS: Issues & Discussions

(VS 2008) New build config looking files from other folder build config

Hi Team, My new build configuration always looking for the files from the build where i copied from. please help me to resolve this. I am using Visual studio 2008.It has Qt 4.8. plugins,qml,C++ development I created new debug_new build configuration with additional preprocessor from the... (1 Reply)
Discussion started by: SA_Palani
1 Replies
libapache2-mod-perl2-2.0.7::docs::api::Apache2::MPM(3pm)User Contributed Perl Documentatiolibapache2-mod-perl2-2.0.7::docs::api::Apache2::MPM(3pm)

NAME
Apache2::MPM - Perl API for accessing Apache MPM information Synopsis use Apache2::MPM (); # check whether Apache MPM is threaded if (Apache2::MPM->is_threaded) { do_something() } # which mpm is used my $mpm = lc Apache2::MPM->show; # query mpm properties use Apache2::Const -compile => qw(:mpmq); if (Apache2::MPM->query(Apache2::Const::MPMQ_STATIC)) { ... } Description "Apache2::MPM" provides the Perl API for accessing Apache MPM information. API
"Apache2::MPM" provides the following functions and/or methods: "query" Query various attributes of the MPM my $query = Apache2::MPM->query($const); obj: $class ( "Apache2::MPM class" ) the class name arg1: $const ( "Apache2::Const :mpmq group constant" ) The MPM attribute to query. ret: $query ( boolean ) the result of the query since: 2.0.00 For example to test whether the mpm is static: use Apache2::Const -compile => qw(MPMQ_STATIC); if (Apache2::MPM->query(Apache2::Const::MPMQ_STATIC)) { ... } "is_threaded" Check whether the running Apache MPM is threaded. my $is_threaded = Apache2::MPM->is_threaded; obj: $class ( "Apache2::MPM class" ) the class name ret: $is_threaded ( boolean ) threaded or not since: 2.0.00 Note that this functionality is just a shortcut for: use Apache2::Const -compile => qw(MPMQ_IS_THREADED); my $is_threaded = Apache2::MPM->query(Apache2::Const::MPMQ_IS_THREADED); "show" What mpm is used my $mpm = Apache2::MPM->show(); obj: $class ( "Apache2::MPM class" ) the class name ret: $mpm ( string ) the name of the MPM. e.g., "Prefork". since: 2.0.00 See Also mod_perl 2.0 documentation. Copyright mod_perl 2.0 and its core modules are copyrighted under The Apache Software License, Version 2.0. Authors The mod_perl development team and numerous contributors. perl v5.14.2 2011-02-08 libapache2-mod-perl2-2.0.7::docs::api::Apache2::MPM(3pm)
All times are GMT -4. The time now is 05:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy