hey guys need help with Mysql!!

nawar youssef · October 8th, 2011, 01:37 AM

I did every step in the book to setup the mysql and the root and everything is good so I can lunch the database engine and the terminal window shows the

"Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.9 Source distribution"
but after that most of the commend I write does not work some of them like help and quit it works but the other like the SELECT ---- FROM ---
doesn't works it shows like this :

" ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'user' "

so please anybody could help me?

I wanna start work with DB!!!

thanks

UseLess · October 8th, 2011, 04:37 AM

Greetings,

Did you login to the db server using a username/password? Because it looks like no user is specified as the error usually says something like: command denied to user "root@localhost" etc.

So make sure you are specifying a username when logging in to the server.

I would also go and download this: http://dev.mysql.com/downloads/workbench/ and once you get it installed you'll then be able to add users and grant permissions to users more easily.

nawar youssef · October 8th, 2011, 05:00 PM

I had nothing tell me that I have to log in, becasue its the first time and I want just to make a username and password as the book tell, but any of the command work. so i don't know
and I am gonna try the download, but should I do anything else or just downloading it? I mean should I uninstall anything eles?
thaks

nawar youssef · October 8th, 2011, 08:08 PM

I installed the Mysql from the link but I did not know how to work and who to start,
are the commands here the same of the book or different?
if not who to make an admin username and pasword with the mysql that
come with MAMP?
thanks .

UseLess · October 9th, 2011, 05:00 PM

Greetings,

Never used MAMP but if it's the same as XAMP then there should be a user of 'root' setup when it's installed. So try logging in to the db server with that username, the password should be whatever you setup when installing MAMP.

nawar youssef · October 9th, 2011, 11:09 PM

can you please tell me how to log in to the sql in Terminal on mac, OR
how can I log in to the sql that I download from the link you gave me, I download it but did not know who to work on it ?

UseLess · October 10th, 2011, 02:50 AM

Greetings,

Use: mysql -u root

If you connect successfully then you should use:

Code:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password');

to change the password for the root user.

You should then quit the MySQL command prompt using:

Code:

\q

and then re-login with:

Code:

mysql -u root -p

You'll then be asked to supply the password you setup earlier. Entering the correct password will then log you in again.

nawar youssef · October 10th, 2011, 12:35 PM

I tried that but you right I need a password ... but I can not make a user name and password while I am not able to access this is the code I write and the answer :

nawaryoussef1s-MacBook-Pro:~ nawaryoussef$ /Applications/MAMP/Library/bin/mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

so any other solution can give me to solve it please,
thanks. and i am sorry for that.

UseLess · October 11th, 2011, 03:32 AM

Greetings,

Read this: http://dev.mysql.com/doc/refman/5.0/...passwords.html

You may also need this: http://www.phpmyadmin.net/home_page/index.php which will give you a web based admin facility for MySQL.

nawar youssef · October 11th, 2011, 04:13 PM

I think this is what I am looking for,
the tutorials seem like it has the information I need, and I download mysql workbench and I am gonna start read the documentations with mySql and see.
thank you again.