OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



HOW OUTPUT IS DISPLAYED from MYSQL Command

Open Harvester Systems support questions and answers, bug reports, and development issues.

Moderators: jmacgreg, michael, John

Forum rules
Developer Resources:

Git: You can access our public Git Repository here. Comprehensive Git usage instructions are available on the wiki.

Bugzilla: You can access our Bugzilla report tracker here.

Search: You can use our Google Custom Search to search across our main website, the support forum, and Bugzilla.

Questions and discussion are welcome.

HOW OUTPUT IS DISPLAYED from MYSQL Command

Postby professionalspring » Wed Jun 05, 2013 3:24 pm

Why is the output from a mysql command line displayed unformatted? Is my 'select * from table' statement not enough? I would like for the output to at least be shown in a formatted table.

Thanks,

Tommy
professionalspring
 
Posts: 13
Joined: Fri May 31, 2013 10:12 am

Re: HOW OUTPUT IS DISPLAYED from MYSQL Command

Postby asmecher » Wed Jun 05, 2013 3:32 pm

Hi Tommy,

I'm not sure what you're asking. Are you talking about accessing MySQL via the command line on your server? Or something within OHS?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8833
Joined: Wed Aug 10, 2005 12:56 pm

Re: HOW OUTPUT IS DISPLAYED from MYSQL Command

Postby professionalspring » Wed Jun 05, 2013 4:07 pm

Hi Alec,

Via the wamp server's MySQL console, I would like to view the records table. Sorry if this was posted in the wrong forum's section. I thought the server was part of the OHS system.

Thanks,

Tommy
professionalspring
 
Posts: 13
Joined: Fri May 31, 2013 10:12 am

Re: HOW OUTPUT IS DISPLAYED from MYSQL Command

Postby asmecher » Wed Jun 05, 2013 4:25 pm

Hi Tommy,

No, that's not part of OHS. I'd suggest looking at a tool like phpMyAdmin that allows point-and-click DB browsing; OTOH it's probably already included in your WAMP server.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8833
Joined: Wed Aug 10, 2005 12:56 pm

Re: HOW OUTPUT IS DISPLAYED from MYSQL Command

Postby professionalspring » Thu Jun 06, 2013 2:38 pm

Thanks, Alec.

You've been very helpful during this learning process. I'm new to OAI harvesting and especially this OHS program.

I've setup OHS 2.3.2 on my Windows 7, using the wamp server.
I tried the phpMyAdmin but got...

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
professionalspring
 
Posts: 13
Joined: Fri May 31, 2013 10:12 am

Re: HOW OUTPUT IS DISPLAYED from MYSQL Command

Postby asmecher » Thu Jun 06, 2013 3:05 pm

Hi Tommy,

Unfortunately I can only help you here with OHS; this is between your MySQL server and the phpMyAdmin tool. (As the error message says, you're trying to log into MySQL with credentials that it's not allowing.) I'd suggest searching Google for that error message; you should find lots of details.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8833
Joined: Wed Aug 10, 2005 12:56 pm


Return to Open Harvester Systems Support and Development

Who is online

Users browsing this forum: No registered users and 1 guest

cron