MySQL and the time it would take you to setup

  • SecureITGroup
  • Proficient
  • Proficient
  • User avatar
  • Posts: 293

Post 3+ Months Ago

I have linux red hat 9 server running. It is a web/ftp/ssh server and it is runnign great i am hosting a forum on it using the mysql database that is installed by default. Now i am ready to setup a database for all of the users so everyone can host a phpbb forum by going to there sub domain. What i am look for is a quick to the point article that shows step by step on seting up a database. And you are probally wondering about my subject line, I wanted to know how long it would take you to setup a basic database. This is to know how complicated it is. After Creating a database i enter these commands

mysql> GRANT ALL PRIVILEGES ON *.* TO 'myaccountname'@'localhost'
-> IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

if follows by

"You have a error in your SQL syntax near 'privelges on *.* to 'myaccount'@'localhost'
identified by mypassword' with gr' at line 1"
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Scorpius
  • Proficient
  • Proficient
  • User avatar
  • Posts: 401
  • Loc: Scorpion Hole

Post 3+ Months Ago

Well, if you don't know a lot about MySQL, you should probably download phpMyAdmin. It is very easy to add/remove users and databases. You will probably have to be logged in as root, or whatever your user is with the GRANT privilege.
You can grab phpMyAdmin here:
http://sourceforge.net/projects/phpmyadmin/
  • Carnix
  • Guru
  • Guru
  • User avatar
  • Posts: 1098

Post 3+ Months Ago

Scorpius wrote:
Well, if you don't know a lot about MySQL, you should probably download phpMyAdmin. It is very easy to add/remove users and databases. You will probably have to be logged in as root, or whatever your user is with the GRANT privilege.
You can grab phpMyAdmin here:
http://sourceforge.net/projects/phpmyadmin/


Absolutely. If you're not familiar with mySQL, or even more so, if you're not comfortable with Linux cmd lines, download and install phpMyAdmin. Actually... even if you are, install it anyway. It makes things so much easier.

You can set up a database in minutes, to answer your question. The initial config for mySQL server takes some time, you want to make sure you've properly hardened it based on what you're going to use it for (if its going to be running on a public production environment, you need to do some extra work than if it's going to be used privately, for example).

You can get solid instructions from mysql.com on that.

.c

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 79 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.