Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Adminstering MySQL - what is the easiest method.
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Adminstering MySQL - what is the easiest method.
Adminstering MySQL - what is the easiest method.
15-08-2007 7:48 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I am a newby to this MYSQL stuff. I want to set up a simple database to manage a web forum I want to set up. I am used to using MS Access but can't seem to get started on MYSQL - how to add tables, add fields, link tables etc.
I can see my the default database set up by F9 and can access this with PHP, the email I received on activation said that there was training and instructions on the MySql portal and a link provided. I can't seem to find anything at the right level.
Can anyone tell me what is the easiest way to administer a MySql database, is the portal best or is there some software to download to database to my PC and then upload back to the website.
Any tips or pointers greatly appreciated.
Thnx.
I can see my the default database set up by F9 and can access this with PHP, the email I received on activation said that there was training and instructions on the MySql portal and a link provided. I can't seem to find anything at the right level.
Can anyone tell me what is the easiest way to administer a MySql database, is the portal best or is there some software to download to database to my PC and then upload back to the website.
Any tips or pointers greatly appreciated.
Thnx.

Message 1 of 4
(2,497 Views)
3 REPLIES 3
Re: Adminstering MySQL - what is the easiest method.
15-08-2007 7:52 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Use phpMyAdmin.
On the member centre, click tools at the bottom of the left menu, then MySQL Admin. Select your server and enter login/pass.
You can do pretty much anything you need from there including creating tables, fields, importing csv data and exporting.
On the member centre, click tools at the bottom of the left menu, then MySQL Admin. Select your server and enter login/pass.
You can do pretty much anything you need from there including creating tables, fields, importing csv data and exporting.
Message 2 of 4
(759 Views)
Re: Adminstering MySQL - what is the easiest method.
15-08-2007 8:38 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thanks Peter, Up and running using the Portal, I am looking forward to getting into this.
I must admit though the cmds like the below leave me a bit baffled, Do you use these in somthing like PuTTY or CShell to administer the db one comand at a time?
create db_name //Create a new database named db_name.
Thanks for your help.
I must admit though the cmds like the below leave me a bit baffled, Do you use these in somthing like PuTTY or CShell to administer the db one comand at a time?

create db_name //Create a new database named db_name.
Thanks for your help.
Message 3 of 4
(759 Views)
Re: Adminstering MySQL - what is the easiest method.
15-08-2007 9:04 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
No, they are MySQL commands and can be used either using the command line MySQL client (run from the cshell prompt) or within phpMyAdmin.
Note: you cannot create any databases as it has already been done for you, but you can have as many tables and fields within the database as you like.
Note: you cannot create any databases as it has already been done for you, but you can have as many tables and fields within the database as you like.
Message 4 of 4
(759 Views)
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Adminstering MySQL - what is the easiest method.