Web Hosting Forum | Lunarpages

Author Topic: Do I need to make mysql user before I can use phpmyadmin?  (Read 4582 times)

Offline TerenceW

  • Trekkie
  • **
  • Posts: 12
Do I need to make mysql user before I can use phpmyadmin?
« on: June 16, 2013, 01:10:41 PM »
Hi, am a newbee to this.

I'm having usage problems on my drupal blog, and have been told by drupal the problem is likely an aggressive spider harvesting my sites content.
They suggested I check out my session table in phpmyadmin, but to do that do I need to set up a user in mysql first?

Also, how do I find my session table?

Thanks
« Last Edit: June 16, 2013, 01:53:31 PM by TerenceW »

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6190
Re: Do I need to make mysql user before I can use phpmyadmin?
« Reply #1 on: June 16, 2013, 02:18:24 PM »
Not that I know of. Have you actually tried just going into into phpMyAdmin and looking around? I have several users set up for several databases, and have never been asked to select a user to use phpMyAdmin. That doesn't mean it's not automatically selecting a/the user when I select a particular database. Come to think of it, if you have Drupal running, you must already have a user defined anyway.

The first thing to try is robots.txt to control where in your site spiders can go. Tell all bots to stay out of places where they have no business going (such as login and profile pages). Some bots may also obey various settings for how long to stay on-site and how often to visit. If some spiders don't obey robots.txt, then once you identify them by IP address, you can deny (ban) them by IP addresses in .htaccess.
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

eothon

  • Guest
Re: Do I need to make mysql user before I can use phpmyadmin?
« Reply #2 on: October 04, 2013, 10:14:12 PM »
Hi,

First of all, if you already have a Drupal installation for your website that is mean you already have a Mysql user. Every time you want to access into phpmyadmin you will need an username and a password, these logging credentials does not have to be the same as the Mysql user and password, many times the logging credentials are the username and password to access into the control panel for the hosting server.

Once you get in to phpmyadmin you will have to take a look around to find the table you want. Usually you will find this under tables options.

 

Share |