MYSQL database Problem

[CeEe4]

Hi Guys

I am trying to set up a mysql database in Backtrack 4 and im having some problems..

First i could not get the service to start at all..


so i had to type

mysqld_safe

and this seemed to start the service
and i could log in by typing..

mysql -u root -p

then entering the password "toor"

but...

How would i create a database with a password on.

can some one help..

Thanks..

[Archangel-Amael]

You should try

root@dorkbox:~# /etc/init.d/mysql start

To start the service. Then to apply a password.

root@dorkbox:~# mysqladmin -u root password passwordhere

Log in by entering:

root@dorkbox:~#  mysql -u root -p

Of course entering the password you applied earlier.


See also:
mysql database - mysql beginners tutorial introduction - mysql server - mysql client
To start learning.

[CeEe4]

Thanks for your quick reply and the great info

ill try this out and let you know how it goes..

i keep getting this after i try and change the root password...

error: Access denied for user root@localhost (using password: NO)

[sickness]

If you want to change the MySQL password try :

mysqladmin -u root -p'oldpassword' password newpass

[roybatty]

Problem is your password wasn't accepted by mysql, so now there's no root password set. Try access as root without password to verify.

Then follow this in order to set it up.
Replace YOURNEWPASSWORD with yours, leave the rest unchanged, quotes included.

[Jaylong]

You should try

root@dorkbox:~# /etc/init.d/mysql start

To start the service. Then to apply a password.

root@dorkbox:~# mysqladmin -u root password passwordhere

Log in by entering:

root@dorkbox:~#  mysql -u root -p

Of course entering the password you applied earlier.


See also:
mysql database - mysql beginners tutorial introduction - mysql server - mysql client
To start learning.

i did it as yours,it is my first time login mysql,i didnot set any password for root,when i

root@bt:~#  mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

so i try

 root@bt:~#  mysql -u root@localhost
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.0.67-0ubuntu6 (Ubuntu)

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

mysql>

but i try setpasswd for root

update user set password=password('mypasswd') where user='root';
ERROR 1046 (3D000): No database selected

and

 show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)

and when i cannot create db

create database radius;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'radius'

i have no idea about this ,how to deal with it

[Puertorock]

Hello Jaylong hope this may help you also it seems you dont have a password in place as per your post (you should be able to login with password toor

root@bt:~#  mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I think whether you have a password or not you have to pass the argument -p (mysql -u root -p

root@bt:~#  mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

 root@bt:~#  mysql -u root@localhost
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.0.67-0ubuntu6 (Ubuntu)

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

mysql>

I noticed when you loged with the command above you got the command line good now try

mysql> help set password

Then try this sir.

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('urnewpass');

Done