How do I set up password on MySQL

[Mackey18]

To log in, I right this in terminal: /usr/local/mysql/bin/mysql -u root

 

I tries setting up my new password like this:

 

/usr/local/mysql/bin/mysql -u root password ******

 

I get a huge list of information!!!

 

How do I set up my password?

[Hybride]

MySQL change password?

[Mackey18]

Sadly when I try this:

 

$ mysqladmin -u root password NEWPASSWORD

 

I get this:

 

-bash: $: command not found

 

I'm running MySQL 5.0 on Mac OSX 10.6.1

[MadTechie]

Don't include the $

mysqladmin -u root password NEWPASSWORD

[Mackey18]

-bash: mysqladmin: command not found

 

I thought you had to include the location of the file,

 

/usr/local/bin/mysqladmin password NEWPASSWORD

 

but that didn't work either. I get this message : -bash: /usr/local/bin/mysqladmin: No such file or directory

 

[trq]

You have to include the full path when executables are not on your current path. mysqladmin is one such executable because it is usually setup to be used by root only.

 

I believe the path your looking for is...

 

/usr/local/mysql/bin/mysqladmin

[Mackey18]

We're certainly making progress:

 

/usr/local/mysql/bin/mysqladmin password ******

/usr/local/mysql/bin/mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'

 

[MadTechie]

cd /usr/local/bin/
sudo mysqladmin password NEWPASSWORD

You will be prompted for your Mac root password,

 

if that fails, just go into mySQl client and do

password = password('newpass')

[Mackey18]

cd /usr/local/bin/

sudo mysqladmin password NEWPASSWORD

 

i got this:

 

cd: /usr/local/bin: No such file or directory

 

mysql> password = password(******)

 

I got this:

 

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password = password(******)' at line 1

 

 

 

[MadTechie]

1.change the CD to the bin path of mysql

 

2. you forgot the quotes

[Mackey18]

So like this:

 

bin /usr/local/bin sudo mysqladmin password ******

 

?

[MadTechie]

cd /usr/local/mysql/bin/

sudo mysqladmin password NEWPASSWORD

[Mackey18]

sudo: mysqladmin: command not found

 

This is rediculous, I wish there was a physical program for mysql as opposed to doing all of this in terminal as obviously something is very very wrong!!

[MadTechie]

what one was not found ?

try su instead of sudo

 

shame i don't have a Mac at home, i could of jumped on one at work!

 

if the access problem is due to it being inuse then try this

/etc/init.d/mysql stop
cd /usr/local/mysql/bin/
safe_mysqld --skip-grant-tables
mysqladmin -u root password 'newpassword'
/etc/init.d/mysql restart

 

or

/etc/init.d/mysql stop
cd /usr/local/mysql/bin/
safe_mysqld --skip-grant-tables
mysql -u root mysql
UPDATE user SET Password=PASSWORD('newpassword') WHERE User='root';

Exit with ctrl+c or ctrl+z or ctrl+x (i really can't remember)

/etc/init.d/mysql restart

try it now

 

[Mackey18]

Again not working, i'll break it down for you:

 

/etc/init.d/mysql stop

gives: -bash: /etc/init.d/mysql: No such file or directory

 

safe_mysqld --skip-grant-tables

gives: -bash: safe_mysqld: command not found

 

the others show no errors

 

Are there any programs which I can buy/download that help me make a database for the website which I asked about in another thread?

[MadTechie]

Erm..the MySQL daemon probably isn't running

SU -

enter root password

/sbin/chkconfig mysqld on
/sbin/service mysqld start

enter root password,

I'm sure the service is stored their..

 

EDIT: Then previous post

[Mackey18]

Again another error, it doesn't matter I don't have to use a password. If you can remember the post about my website MadTechie, would you think there is any way to accomplish what a wanted without using MySQL?

 

Thanks for your help, you've been a star!

[MadTechie]

Oh I remember you now..

do you still have phpmyadmin access ?

if so you can use that to create a new user, (by clicking Privileges->Add user)

[Mackey18]

Yes I do, i'll have a quick look then i'll head off to bed, it's nearly mid night!

[Mackey18]

Hmm this is the link my web host sent  me (in attachment), i log in and this is what I see, What is it?

 

I blanked out lots of info as i wasn't sure if it was sensitive!!!

 

[attachment deleted by admin]

[MadTechie]

1. click Privileges

2. click Add a new User

3.1.User name = test

3.2 Host: LocalHost

3.3 Password = pass

3.4 Retype = pass

4. Global privileges tick all in Data & Structure

5. click go

 

Now click the Databases tab

Create new database

enter name (ie testing) click create

Then

Create new table on database testing

.. i think the tutorial plays form here

 

[Mackey18]

Look at the picture i sent, there is no button for privileges!

 

EDIT: I haven't downloaded PHPmyAdmin to my Mac yet, at the moment it's just a webpage which I took the screenshot of.

 

EDIT: An account came with my domain name when I bought it, the screenshot is the page after I logged in.

[fenway]

Who set this up?