Fedora Linux Support Community & Resources Center

Go Back   FedoraForum.org > Fedora 17/18 > Servers & Networking
FedoraForum Search

Forgot Password? Join Us!

Servers & Networking Discuss any Fedora server problems and Networking issues such as dhcp, IP numbers, wlan, modems, etc.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 2nd June 2009, 10:47 PM
Booma Offline
Registered User
 
Join Date: Oct 2006
Location: London
Age: 41
Posts: 26
Having trouble creating Databases

Hello,

I'm having trouble creating databases. Privileges prevents phpmyadmin from doing so, which makes sense, but I'm having using mysqladmin and mysql in the shell, where connecting to localhost as root ect but nothing seems to happen.

Can anyone offer any advice about how others create new databases?

Many thanks
Reply With Quote
  #2  
Old 2nd June 2009, 10:55 PM
pete_1967 Online
Clueless in a Cuckooland
 
Join Date: Mar 2006
Location: Here now, elsewhere tomorrow.
Posts: 3,916
Code:
mysql -u dbadmin -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database foo;
Query OK, 1 row affected (0.02 sec)

mysql> show databases;
+----------------------------------+
| Database                         |
+----------------------------------+
| information_schema               | 
| comicsite                        | 
| dc_web                           | 
| discoverycollectioncom_87544_db1 | 
| foo                              | 
| mysql                            | 
| postcard                         | 
+----------------------------------+
7 rows in set (0.02 sec)

mysql>
__________________
A Drink is Not Just For Christmas - SaskyCom :thumb:


“Give a man a fish; you have fed him for today. Teach a man to fish; and you have fed him for a lifetime” so now go and...
RTFM FIRST: http://docs.fedoraproject.org/ & http://rute.2038bug.com/index.html.gz
Reply With Quote
  #3  
Old 3rd June 2009, 09:46 PM
Booma Offline
Registered User
 
Join Date: Oct 2006
Location: London
Age: 41
Posts: 26
That's great and works but...

Thank you, that works, however I cannot see the databases in phpmyadmin, even after restarting the services.

What do you think?

Many thanks.
Reply With Quote
  #4  
Old 4th June 2009, 03:25 PM
neogranas Offline
Registered User
 
Join Date: Nov 2006
Location: U.S.A.
Age: 27
Posts: 473
What user are you using to log in to phpMyAdmin and what privileges does that user have in the mysql.users table?
__________________
Registered linux user: #475337

Never underestimate someone with source code, a text editor, and the willingness to completely hose their system.
Reply With Quote
Reply

Tags
creating, databases, trouble

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble creating image from iso in Fedora Live 6 trents Installation and Live Media 5 5th March 2007 05:39 AM
Windows Vista creating trouble for Linux users? Perty Linux Chat 23 29th December 2006 03:09 AM
yum - different databases? rob2000007 Using Fedora 1 29th September 2005 01:24 AM
Databases in Linux kumarannair Using Fedora 2 4th December 2004 05:04 PM


Current GMT-time: 22:42 (Saturday, 18-05-2013)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat