I have installed mysql just now ,but i dont know how to change the root password .
as i type in './mysql_secure_installati
Enter current password for root (enter for none):
and I type some word or none and enter , it shows:
Set root password? [Y/n]: , I type Y,and type in my new password two times ,but at last ,it said :
./mysql_secure_installatio
Password update failed!
I dont know why, the guide document I follow ask me to type in 'mysqladmin' to change password, but I can not find the mysqladmin script or execurte file. but in the /usr/bin , 'mysql_secure_installation
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
first type "mysql" : if you get "command not found", put the installationdir of mysql plus '/bin' in your path ;-)
then do :
mysql --user=root
(type enter for empty password)
then change the password for root :
update mysql.user set Password=PASSWORD('your_ne
flush privileges;
quit;
that's all
my install file is rpm, mysqll-server-4**.rpm
and I use rpm -ivf to install it ,but I dont kown how to specify the installation directory
I still can not find the directory .
i download the mysql from www.mysql.com -> download
there is a version with '(recommanded)' mark.
Hi Sam80,
I have just downloaded MySQL from http://www.mysql.com/ the RPMs for Linux i86 and install it on RedHat 7.3. The packages I installed are as follows:
MySQL-devel-4.0.13-0
MySQL-client-4.0.13-0
MySQL-shared-4.0.13-0
MySQL-server-4.0.13-0
MySQL-Max-4.0.13-0
all mysql binaries (mysql, mysqladmin, etc) are located in /usr/bin. Just do mysqladmin -u root password 'newpassword' to change the admin password.
To check which rpm you have installed, do:
$ rpm -qa | grep mysql; rpm -qa | grep MySQL
To uninstall the packages (take the above MySQL packages as example),
$ rpm -e MySQL-devel MySQL-client MySQL-shared MySQL-server MySQL-Max
rpm will remove all the packages.
thanks slyong, I have uninstall it successful ,and now ,I should learn how to config the linux server
the function it includes should be :
web server - apache + tomcat
mail & database server - qmail + mysql + some administrate software
the qmail should connect to the mysql (i am unable to describe in detail ,maybe like some infomation on web about qmail + mysql )
please give me some correct direction to follow.
Hi Sam80,
now you see other helping u :)
VGR is the expert's expert here, I try my best to catch up like him, but failed :(
you may try using 'setup' in the command console, select the 'System service', go down and un check the sendmail service, this will do :)
or go to /etc/rc.d/rc3.d/ remove the link some like 'S80sendmail -> ../init.d/sendmail',will also do :)
Paul
oh for about the administration software, try the webmin is a good tool to know you can get it here http://www.webmin.com/ , try it sure you will love it.
I suggest you better put your difference question into other area ;)
I see!! I dont install the mysql-client !!! ,after I install it ,I can run 'mysql' and 'mysqladmin'
and now the problem is : when I use the syntax from VGR ,
update mysql.user set Password=PASSWORD('your_ne
it shows :
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql>
woo!!!! I did it ,I can config my root password in mysql.
now I do "select * from mysql.user where User='root'" it shows two records to me.
host | User | Password
local | root | 23d234sdksdf (encrypted pwd)
localhost | root | 23d234sdksdf (encrypted pwd)
the password are the same because I update both to the same password where the user='root'
in VGR's syntax, it just update the password where the host='localhost'
will it be all right ?
Sam80,
I have phpMyAdmin (http://www.phpmyadmin.net
$ rpm -Uvh httpd-xxx.rpm php-xxx.rpm php-mysql-xxx.rpm
then as root restarts all services
$ su -
# init 5
You should have apache, php installed... take it from there to install phpMyAdmin.
well, here's wat ***usually*** is in there (congratulations for having solved your problem by yourself :D )
-localhost/root/password
-%/root/password
-127.0.0.1/root/password
and you have to add new users (with more limited privileges) for using in your programs. It's a slight security issue to use 'root' which is fully-priviledged (can DROP DATABASE etc)
Dear ,
I have the Explaination in a Word File Application , if you need the
solution , please send an Email Address and I will Reply you the
File ...
Sincerely ..
Rabia Abu-Hanna
Nazareth - Israel
MCP-MCSD-Software Engineer
http://www14.brinkster.com
Set Password to SQL Server 7.0/2000
By : Rabia Abu-Hanna
1. We need Open the Following Path :
[Console Root ] >>> [Microsoft SQL Servers] >>> [SQL Server Group] >>> [Server Name] >>> [Security] >>> [Logins] >>>
We need to Open the Properties of “ BUILTIN\Administrators “ and then to Choose into the Topic “General” :
( Deny Access ) of the Windows NT Authentication .
2. We need to open the Properties of the user : “sa”
To Choose : SQL Server Authentication and then Add the
Password for the “sa” username !!!!
3. To Return back to the Basic Window of the SQL , and to Click
Right Click on the [Server Name] >>> [Edit SQL Server Registration Properties] >>> and then to choose :
“Use SQL Server Authentication”
set the username = “sa”
Select the CheckBox at bottom “Always prompt for Login name and password “ , and then to Click ok ..
4. From the Visual Basic Module :
We Need to Create the Connection String For Exp. :
strCnn = "Provider=SQLOLEDB.1;Initi
From the Connection Options we need to Call the Statement as follows :
With cn
.Open strCnn, "sa", "*********"
End With
Business Accounts
Answer for Membership
by: slyongPosted on 2003-07-15 at 03:30:51ID: 8924118
Hi Sam80,
Depending on what you install (source, rpm, binary distribution, pkg) mysql files might be in different locations. Look into /usr/bin, /usr/local/bin and try to find mysqladmin there.