Creating a mysql database and tables

Normally where would you set phpMyAdmin to create databases and tables?  I am completely new to phpMyAdmin and want to make sure I don't start off wrong and have to redo everything.  Thanks!
LVL 1
pingeyegAsked:
Who is Participating?
 
steelseth12Connect With a Mentor Commented:
no \mysql\data is where the actual databases are created and its outsite the document root.

just make a folder mysql/upload for $cfg['UploadDir'] and mysql/download for $cfg['SaveDir']
0
 
steelseth12Connect With a Mentor Commented:
\mysql\data
0
 
pingeyegAuthor Commented:
So, for instance, if I have the following, what would I do to make it go to that?

$cfg['UploadDir'] = 'http://localhost/';
$cfg['SaveDir'] = 'http://localhost/';
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
steelseth12Commented:
$cfg['UploadDir']  and $cfg['SaveDir'] as just the directories where sql files and sql dumps will be stored ... its not where the databases are created.

0
 
pingeyegAuthor Commented:
So you are saying, if I'm following you correctly, that I would make both $cfg['UploadDir']  and $cfg['SaveDir'] to point to \mysql\data?
0
 
pingeyegAuthor Commented:
One other thing, what does Collation mean?  I see everything except for english.
0
 
steelseth12Connect With a Mentor Commented:
if you are using only english set it to latin_bin or latin_general_ci for case insensitive
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.