create new database using phpMyAdmin
Moderator: General Moderators
create new database using phpMyAdmin
I am using a mac 10.2.4 and have phpMyAdmin up. when i go to the index.php in my phpMyAdmin folder on my localhost the link for Create new database is not clickable. I see the test db and have used yourSQL to create a new test_ db, but cant create a new db using phpMyAdmin.
The page says:
Welcome to phpMyAdmin 2.4.0
MySQL 3.23.55-entropy.ch running on localhost as mysql@localhost
but i cant create new dbs. Should i be loging in with a new user and password? Any advice on what I am doing wrong? What is you preference: phpMyAdmin or yourSQL?
Thanks
The page says:
Welcome to phpMyAdmin 2.4.0
MySQL 3.23.55-entropy.ch running on localhost as mysql@localhost
but i cant create new dbs. Should i be loging in with a new user and password? Any advice on what I am doing wrong? What is you preference: phpMyAdmin or yourSQL?
Thanks
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
The mysql user is the root user without a password (so in the config file the password is blank, i think thats rigth), should the root user have the privileges to create new dbs or do I need to set the privileges?
Would it be better to create a new user with the right privileges? Can i do that using phpMyAdmin?
Would it be better to create a new user with the right privileges? Can i do that using phpMyAdmin?
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Have you tried connecting as user 'root'? If you want to add users and check their privileges click on the 'Privileges' link on your phpMyAdmin home page. You can also add users and check privileges using the command line:
http://www.mysql.com/doc/en/SHOW_GRANTS.html
http://www.mysql.com/doc/en/GRANT.html
http://www.mysql.com/doc/en/Default_privileges.html
http://www.mysql.com/doc/en/Adding_users.html
Mac
http://www.mysql.com/doc/en/SHOW_GRANTS.html
http://www.mysql.com/doc/en/GRANT.html
http://www.mysql.com/doc/en/Default_privileges.html
http://www.mysql.com/doc/en/Adding_users.html
Mac
Thanks for your help Mac.
I tried using root, but got an error. Isnt root with no password created when the mysql is installed -- along with all priveleges. in phpMyAdmin the link for are there, but not clickable
I followed this tutorial to get setup:
http://www.macromedia.com/devnet/mx/dre ... ntosh.html
thanks for the links. i have some reading to do.
I tried using root, but got an error. Isnt root with no password created when the mysql is installed -- along with all priveleges. in phpMyAdmin the link for
Code: Select all
Create new database: їDocumentation]
No PrivilegesI followed this tutorial to get setup:
http://www.macromedia.com/devnet/mx/dre ... ntosh.html
thanks for the links. i have some reading to do.
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK