How to install a mysql database in cpanel?

texasgamer · 03-07-2007, 10:09 PM

I am a complete noob on mysql databases or how to install one. Is there a simple and easy to understand tutorial on how to install a mysql database in cpanel?
thanks

Constantin · 03-08-2007, 02:02 AM

I suppose you want to say "create" instead of "install".

- in cpanel go to "MySQL® Databases"
- Create database
- Create User
- Add User to Database

All steps are needed.

Then you can use phpMyAdmin to create/edit tables.

**enlytend** · 03-08-2007, 04:51 AM

.. and please only give the user the privileges they need. If your site users will only need to look up information (select), don't give them things like update, alter, create, insert, delete, drop ...

webdrafter · 03-08-2007, 06:16 AM

hey here's a video

http://support.afrihost.com/web-host..._xv2_mysql.htm

I have used mysql for scripts that i bought and the thing i always have to remember for the database name and user name is that it puts my cpanel name in front of it and underscore the database name and username. That's the info I end up using in the config.php file that i have to manipulate.

I am a total novice for mysql by I use them with scripts that i buy,

hope this helps,

Lisa

03-07-2007, 10:09 PM	THREAD STARTER #1 (permalink)
texasgamer Senior Member Join Date: Jan 2006 Location: Corpus Christi, Texas Posts: 2,373	How to install a mysql database in cpanel? I am a complete noob on mysql databases or how to install one. Is there a simple and easy to understand tutorial on how to install a mysql database in cpanel? thanks __________________ Sara Palin

03-08-2007, 02:02 AM	#2 (permalink)
Constantin Senior Member Join Date: Jan 2006 Posts: 1,127	I suppose you want to say "create" instead of "install". - in cpanel go to "MySQL® Databases" - Create database - Create User - Add User to Database All steps are needed. Then you can use phpMyAdmin to create/edit tables. __________________ ConcertManiacs.com - all your concerts in one place

03-08-2007, 04:51 AM	#3 (permalink)
enlytend Forum Moderator Join Date: Aug 2006 Location: USA Posts: 2,152 Follow @enlytend	.. and please only give the user the privileges they need. If your site users will only need to look up information (select), don't give them things like update, alter, create, insert, delete, drop ...

03-08-2007, 06:16 AM	#4 (permalink)
webdrafter NamePros Member Join Date: Jul 2006 Posts: 32	hey here's a video http://support.afrihost.com/web-host..._xv2_mysql.htm I have used mysql for scripts that i bought and the thing i always have to remember for the database name and user name is that it puts my cpanel name in front of it and underscore the database name and username. That's the info I end up using in the config.php file that i have to manipulate. I am a total novice for mysql by I use them with scripts that i buy, hope this helps, Lisa

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)