vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello..Have an issue that my hosting service wont answer... I'm learning MYSQL 4.1 through a book..and noticed some problems after connecting to my account through a linux shell. I created 3 mysql accounts..(all, ro, and rw) and logged into the server using: mysql -u lcdirect_lcd-all -p -h custsql.***.net Whenever I type a command that doesn't have errors I don't get a response. Here is what happened : ------------- Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9940606 Server version: 4.1.22-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE monster; USE monster; CREATE TABLE users ( user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, first_name VARCHAR(15) NOT NULL, last_name VARCHAR(30) NOT NULL, email VARCHAR(40) NOT NULL, password CHAR(40) NOT NULL, registration_date DATETIME NOT NULL, PRIMARY KEY (user_id) ); SHOW TABLES; SHOW TABLES; SHOW COLUMNS FROM users; \h Nothing ever is displayed after I try and display the tables I supposedly created.. not even the help command.I logged out and logged back in...and typed: mysql> USE monster; ERROR 1044 (42000): Access denied for user 'lcdirect_lcd-all'@'%' to database 'monster' I assume all is the admin so I don't understand why the table wasn't stored. Whats interessting is that after I logged out and back in...I could use the \h command and it works...after I try to create a table with columns, I can't "see" anything. PLEASE HELP! I really DON'T want to have to use PHPBB. Thanks! |