yer thats it i did get it in the end , but i was to sleepy to post, but now its another day..
does this look ok ?
Changing root password for mysql <-------
mysqladmin -u root password 'new_password'
mysql -u root password 'new_password'
mysql> SET PASSWORD FOR root@localhost=PASSWORD 'new_password'
Showing databases <----------
[root@www downloads]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 43 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases; <------command
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)
mysql>
Creating a database <--------
[root@www downloads]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 44 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database nuke; <----command
Query OK, 1 row affected (0.00 sec)
mysql> \q
Bye
test to see if database nuke is there <-----------
[root@www downloads]# mysql nuke -u root -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases; <---command
+----------+
| Database |
+----------+
| mysql |
| nuke |
| test |
+----------+
3 rows in set (0.00 sec)
mysql>
[root@www downloads]#
importing the sql file, must be in the directory were the sql file is.
[root@www downloads]# mysql -u root -p nuke </home/tommytomato/downloads/nuke.sql
Enter password:
[root@www downloads]#
show tables <---------# mysql your_database -u root -p
mysql> \q
Bye
[root@www downloads]# mysql nuke -u root -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 48 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables; <-----command
+----------------------------+
| Tables_in_nuke |
+----------------------------+
| confirm |
| nuke_authors |
| nuke_autonews |
| nuke_banner |
| nuke_bannerclient |
| nuke_bbauth_access |
| nuke_bbbanlist |
| nuke_bbcategories |
| nuke_bbconfig |
| nuke_bbdisallow |
| nuke_bbforum_prune |
| nuke_bbforums |
| nuke_bbgroups |
| nuke_bbposts |
| nuke_bbposts_text |
| nuke_bbprivmsgs |
| nuke_bbprivmsgs_text |
| nuke_bbranks |
| nuke_bbsearch_results |
| nuke_bbsearch_wordlist |
| nuke_bbsearch_wordmatch |
| nuke_bbsessions |
| nuke_bbsmilies |
| nuke_bbthemes |
| nuke_bbthemes_name |
| nuke_bbtopics |
| nuke_bbtopics_watch |
| nuke_bbuser_group |
| nuke_bbvote_desc |
| nuke_bbvote_results |
| nuke_bbvote_voters |
| nuke_bbwords |
| nuke_blocks |
| nuke_comments |
| nuke_config |
| nuke_contactbook |
| nuke_counter |
| nuke_downloads_categories |
| nuke_downloads_downloads |
| nuke_downloads_editorials |
| nuke_downloads_modrequest |
| nuke_downloads_newdownload |
| nuke_downloads_votedata |
| nuke_encyclopedia |
| nuke_encyclopedia_text |
| nuke_ephem |
| nuke_faqAnswer |
| nuke_faqCategories |
| nuke_headlines |
| nuke_journal |
| nuke_journal_comments |
| nuke_journal_stats |
| nuke_links_categories |
| nuke_links_editorials |
| nuke_links_links |
| nuke_links_modrequest |
| nuke_links_newlink |
| nuke_links_votedata |
| nuke_main |
| nuke_message |
| nuke_modules |
| nuke_pages |
| nuke_pages_categories |
| nuke_poll_check |
| nuke_poll_data |
| nuke_poll_desc |
| nuke_pollcomments |
| nuke_popsettings |
| nuke_priv_msgs |
| nuke_public_messages |
| nuke_queue |
| nuke_quotes |
| nuke_referer |
| nuke_related |
| nuke_reviews |
| nuke_reviews_add |
| nuke_reviews_comments |
| nuke_reviews_main |
| nuke_seccont |
| nuke_sections |
| nuke_session |
| nuke_stats_date |
| nuke_stats_hour |
| nuke_stats_month |
| nuke_stats_year |
| nuke_stories |
| nuke_stories_cat |
| nuke_topics |
| nuke_users |
| nuke_users_temp |
+----------------------------+
90 rows in set (0.00 sec)
mysql>
I'm making my own home doc's, does it look ok ?
tommytomato